What percentage of games are sports?
percentage = MULTIPLY(DIVIDE(SUM(genre_name = 'sport'), COUNT(game_name)), 100.0); sports refers to genre_name = 'sport';
SELECT CAST(COUNT(CASE WHEN T1.genre_name = 'Sports' THEN T2.id ELSE NULL END) AS REAL) * 100 / COUNT(T2.id) FROM genre AS T1 INNER JOIN game AS T2 ON T1.id = T2.genre_id
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, 
