Provide the number of games sold in North America on the PS4 platform.
number of games sold refers to sum(multiply(num_sales, 100000)); in North America refers to region_name = 'North America'; on the PS4 platform refers to platform_name = 'PS4'
SELECT SUM(T1.num_sales * 100000) FROM region_sales AS T1 INNER JOIN region AS T2 ON T1.region_id = T2.id INNER JOIN game_platform AS T3 ON T1.game_platform_id = T3.id INNER JOIN platform AS T4 ON T3.platform_id = T4.id WHERE T2.region_name = 'North America' AND T4.platform_name = 'PS4'
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, 
