Easy - Audible

Table: global_weekly_charts_2013_2014

Schema:

pos	int
game	varchar
platform	varchar
publisher	varchar
genre	varchar
week	int
weekly	int
total	int
week_ending	datetime
id	int

Preview:

pos	game	platform	publisher	genre	week	weekly	total	week_ending	id
2352	UFC Personal Trainer: The Ultimate Fitness System	Wii	THQ	Sports	128	1538	153649	2013-12-21	21726
5031	Bleach: The Blade of Fate	DS	Sega	Fighting	281	44	442622	2013-07-13	168837
5725	Gundam Memories: Tatakai no Kioku	PSP	Namco Bandai Games	Action	98	18	122023	2013-05-04	229810
4811	Jurassic: The Hunted	Wii	Activision	Shooter	207	62	136931	2013-10-19	81464
3910	Our House Party!	Wii	Majesco Entertainment	Simulation	186	103	53086	2013-04-13	245724

Find the best publishers based on total sales

Find the best publishers based on total sales made by each publisher. Output publishers alongside their total sales. Order records based on the sales in descending order.

StrataScratch

SELECT publisher, SUM(total) AS total_sales
FROM global_weekly_charts_2013_2014
GROUP BY 1
ORDER BY SUM(total) DESC;

Find the genres that yielded the highest sales

Find the genres that yielded the highest sales. Output the genre alongside its total sales. Order results based on the total sales in descending order.

StrataScratch

SELECT genre, SUM(total) AS total_sales
FROM global_weekly_charts_2013_2014
GROUP BY 1
ORDER BY SUM(total) DESC;

Find details of oscar winners between 2001 and 2009

Find the details of oscar winners between 2001 and 2009.

StrataScratch

Table: oscar_nominees

Schema:

year	int
category	varchar
nominee	varchar
movie	varchar
winner	bool
id	int

Preview:

year	category	nominee	movie	winner	id
2010	actor in a leading role	James Franco	127 Hours	FALSE	648
2003	actor in a supporting role	Benicio Del Toro	21 Grams	FALSE	139
2003	actress in a leading role	Naomi Watts	21 Grams	FALSE	1119
2001	actress in a supporting role	Jennifer Connelly	A Beautiful Mind	TRUE	710
2001	actor in a leading role	Russell Crowe	A Beautiful Mind	FALSE	1315

SELECT * FROM oscar_nominees
WHERE year BETWEEN 2001 AND 2009
AND winner = TRUE