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



 

Would you like to read more?