Database schema:

CREATE TABLE game (
	id INTEGER NOT NULL -- example: ['45', '44'],
	genre_id INTEGER DEFAULT NULL -- example: ['5', '4'],
	game_name TEXT DEFAULT NULL -- example: ['2 Games in 1: Sonic Advance & ChuChu Rocket!', '2 Games in 1: Sonic Battle & ChuChu Rocket!'],
	PRIMARY KEY (id), 
	CONSTRAINT fk_game_genre FOREIGN KEY(genre_id) REFERENCES genre (id)
)


CREATE TABLE game_platform (
	id INTEGER NOT NULL -- example: ['2', '1'],
	game_publisher_id INTEGER DEFAULT NULL -- example: ['9852', '8564'],
	platform_id INTEGER DEFAULT NULL -- example: ['7', '4'],
	release_year INTEGER DEFAULT NULL -- example: ['2006', '2007'],
	PRIMARY KEY (id), 
	CONSTRAINT fk_game_platform_game_publisher FOREIGN KEY(game_publisher_id) REFERENCES game_publisher (id),
	CONSTRAINT fk_game_platform_platform FOREIGN KEY(platform_id) REFERENCES platform (id)
)


CREATE TABLE game_publisher (
	id INTEGER NOT NULL -- example: ['2', '1'],
	game_id INTEGER DEFAULT NULL -- example: ['9244', '10866'],
	publisher_id INTEGER DEFAULT NULL -- example: ['369', '328'],
	PRIMARY KEY (id), 
	CONSTRAINT fk_game_publisher_game FOREIGN KEY(game_id) REFERENCES game (id),
	CONSTRAINT fk_game_publisher_publisher FOREIGN KEY(publisher_id) REFERENCES publisher (id)
)


CREATE TABLE genre (
	id INTEGER NOT NULL -- example: ['2', '1'],
	genre_name TEXT DEFAULT NULL -- example: ['Adventure', 'Action'],
	PRIMARY KEY (id)
)


CREATE TABLE platform (
	id INTEGER NOT NULL -- example: ['2', '1'],
	platform_name TEXT DEFAULT NULL -- example: ['Wii', 'NES'],
	PRIMARY KEY (id)
)


CREATE TABLE publisher (
	id INTEGER NOT NULL -- example: ['2', '1'],
	publisher_name TEXT DEFAULT NULL -- example: ['1C Company', '10TACLE Studios'],
	PRIMARY KEY (id)
)


CREATE TABLE region (
	id INTEGER NOT NULL -- example: ['2', '1'],
	region_name TEXT DEFAULT NULL -- example: ['Europe', 'North America'],
	PRIMARY KEY (id)
)


CREATE TABLE region_sales (
	region_id INTEGER DEFAULT NULL -- example: ['2', '1'],
	game_platform_id INTEGER DEFAULT NULL -- example: ['50', '51'],
	num_sales REAL DEFAULT NULL -- example: ['3.5', '1.43'],
	CONSTRAINT fk_region_sales_game_platform FOREIGN KEY(game_platform_id) REFERENCES game_platform (id),
	CONSTRAINT fk_region_sales_region FOREIGN KEY(region_id) REFERENCES region (id)
)

Question: For all the games which were published by Namco Bandai Games, what percentage of them were adventure games?
Evidence: published by Namco Bandai Games refers to publisher_name = 'Namco Bandai Games'; adventure game refers to genre_name = 'Adventure'; percentage = divide(sum(game_id where genre_name = 'Adventure'), count(game_id)) * 100% where publisher_name = 'Namco Bandai Games'

SQL:
SELECT CAST(COUNT(CASE WHEN T4.genre_name = 'Adventure' THEN T1.id ELSE NULL END) AS REAL) * 100 / COUNT(T1.id) FROM game AS T1 INNER JOIN game_publisher AS T2 ON T1.id = T2.game_id INNER JOIN publisher AS T3 ON T2.publisher_id = T3.id INNER JOIN genre AS T4 ON T1.genre_id = T4.id WHERE T3.publisher_name = 'Namco Bandai Games'