Project in SQL to analyze the golden age of videogames. We explore the top 400 best-selling video games created between 1977 and 2020. We'll compare a dataset on game sales with critic and user reviews to determine whether or not video games have improved as the gaming market has grown.
- Check some of the top selling video games of all time.
SQL Query:
Result:
- Check how many games on the game_sales table don't have any reviews data.
SQL Query:
Result:
- Check what the critics think - the average critic score per year, limiting by 10 results.
SQL Query:
Result:
- Update the previous query so it only returns years that have more than four reviewed games.
SQL Query:
Result:
- Check which years dropped off the list due to having four or fewer reviewed games.
SQL Query:
Result:
- Check the opinion of the players, looking at the average user score per year, limiting results by 10.
SQL Query:
Result:
- Check what are the years that both players and critics loved.
SQL Query:
Result:
- We know that critics and players liked these years, but we need to check if the sales were good in those years.
SQL Query:
Result:
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent