Among the games published by Nintendo, what is the percentage of those in the genre of sports?
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'
database name:db_id video_games
genre table genre Cols: id dtype integer, genre_name dtype text, 
game table game Cols: id dtype integer, genre id dtype integer, game name dtype text, 
platform table platform Cols: id dtype integer, platform_name dtype text, 
publisher table publisher Cols: id dtype integer, publisher_name dtype text, 
game_publisher table game_publisher Cols: id dtype integer, game id dtype integer, publisher id dtype integer, 
game_platform table game_platform Cols: id dtype integer, game publisher id dtype integer, platform id dtype integer, release year dtype integer, 
region table region Cols: id dtype integer, region_name dtype text, 
region_sales table region_sales Cols: region_id dtype integer, game platform id dtype integer, number sales dtype real, 
