DataEngineerBootcamp

Week 4 Applying Analytical Patterns

The homework this week will be using the players, players_scd, and player_seasons tables from week 1

• A query that does state change tracking for players
  • A player entering the league should be New
  • A player leaving the league should be Retired
  • A player staying in the league should be Continued Playing
  • A player that comes out of retirement should be Returned from Retirement
  • A player that stays out of the league should be Stayed Retired
• A query that uses GROUPING SETS to do efficient aggregations of game_details data
  • Aggregate this dataset along the following dimensions
    • player and team
      • Answer questions like who scored the most points playing for one team?
    • player and season
      • Answer questions like who scored the most points in one season?
    • team
      • Answer questions like which team has won the most games?
• A query that uses window functions on game_details to find out the following things:
  • What is the most games a team has won in a 90 game stretch?
  • How many games in a row did LeBron James score over 10 points a game?

Please add these queries into a folder homework/<discord-username>