### Database Schema:
CREATE TABLE game_publisher (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	game_id	INTEGER	NULL	DEFAULT NULL,
	publisher_id	INTEGER	NULL	DEFAULT NULL,
	foreign key (publisher_id) references publisher (id),
	foreign key (game_id) references game (id)
);

CREATE TABLE game_platform (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	game_publisher_id	INTEGER	NULL	DEFAULT NULL,
	platform_id	INTEGER	NULL	DEFAULT NULL,
	release_year	INTEGER	NULL	DEFAULT NULL,
	foreign key (platform_id) references platform (id),
	foreign key (game_publisher_id) references game_publisher (id)
);

CREATE TABLE platform (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	platform_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE game (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	genre_id	INTEGER	NULL	DEFAULT NULL,
	game_name	TEXT	NULL	DEFAULT NULL,
	foreign key (genre_id) references genre (id)
);

CREATE TABLE genre (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	genre_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE region (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	region_name	TEXT	NULL	DEFAULT NULL
);

CREATE TABLE region_sales (
	region_id	INTEGER	NULL	DEFAULT NULL,
	game_platform_id	INTEGER	NULL	DEFAULT NULL,
	num_sales	REAL	NULL	DEFAULT NULL,
	foreign key (region_id) references region (id),
	foreign key (game_platform_id) references game_platform (id)
);

CREATE TABLE publisher (
	id	INTEGER	NOT NULL	PRIMARY KEY,
	publisher_name	TEXT	NULL	DEFAULT NULL
);

### User's Query:
Among the games published by Nintendo, what is the percentage of those in the genre of sports?

### Extra Knowledge:
published by Nintendo refers to publisher_name = 'Nintendo'; in the genre of sports refers to genre_name = 'Sports'; percentage = divide(count(game_id where genre_name = 'Sports'), count(game_id)) * 100% where publisher_name = 'Nintendo'
SELECT CAST(COUNT(CASE WHEN T4.genre_name = 'Sports' 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 = 'Nintendo'