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: Provide the number of games sold in North America on the PS4 platform.
Evidence: 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'

SQL:
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'