fbpx

SQL Data Analysis Exercises – Facebook Games

This SQL exercise is a part of a section dedicated for data analysts , providing data analysis tasks that require both business understanding and technical skills.

 

About this Exercise

From shooters to strategy, builders to bingo. Facebook platform allows users from all around the world to play, watch, and share their games.
The following dataset simulates some of data stored by Facebook, and includes the following tables :

  • facebook_games – lists the available games
  • facebook_members – contains the different members / Facebook users
  • friendships – lists the connections between the various Facebook members
  • games_and_players – displays the games each player is playing

 

Diagram



 

To read more

UpScale Analytics is one of the largest platforms in the world for learning SQL by doing, consisting over 300 SQL exercises at different levels (including solutions), by topics, across over 100 different datasets. More…