SELECT Developer, Game_name
FROM Games
WHERE Developer IS NOT NULL
ORDER BY Developer ASC;

SELECT Year_of_Release, COUNT(*) as games_count
FROM Games
WHERE Platform = 'Wii'
GROUP BY Year_of_Release
ORDER BY Year_of_Release ASC;

SELECT DISTINCT Developer
FROM Games
WHERE Platform = 'PC' AND Developer IS NOT NULL
ORDER BY Developer ASC;

SELECT COUNT(*) as games_count
FROM Games
WHERE Platform = 'PS4' AND JP_Sales > NA_Sales;

SELECT Game_name, Critic_Score
FROM Games
WHERE Platform = 'PC' AND Genre = 'Shooter' AND Year_of_Release = '2013' AND Critic_Score >= 80
ORDER BY Critic_Score DESC;

SELECT Developer, Genre, COUNT(*) as games_count
FROM Games
WHERE Developer IS NOT NULL
GROUP BY Developer, Genre
ORDER BY Developer DESC;

SELECT Game_name, (NA_Sales + EU_Sales + JP_Sales) as global_sales_sum
FROM games
WHERE Year_of_Release = '2013' AND (NA_Sales + EU_Sales + JP_Sales) > 10
ORDER BY global_sales_sum DESC;

SELECT Platform, Year_of_Release,
       SUM(NA_Sales) as na_sales_sum,
       SUM(EU_Sales) as eu_sales_sum,
       SUM(JP_Sales) as jp_sales_sum
FROM games
WHERE Year_of_Release IN ('2006', '2007')
GROUP BY Platform, Year_of_Release
ORDER BY Platform DESC;