Basketball Data Scenario Analysis | Dataford Interview Questions

Tell me about a time you analyzed basketball game data scenarios to answer a specific question.

For this SQL exercise, use the Oklahoma City Thunder game and team statistics tables to compare three-point shooting in regular-season wins and losses.

Output

One row per result type, either Win or Loss.
Return outcome, games_analyzed, average_three_point_percentage, and average_point_margin.
Include only games with matching Oklahoma City statistics and order results with Win before Loss.

Schema

games

Column	Type	Description
game_idPK	INT	Unique game identifier
game_date	DATE	Date on which the game was played
season	INT	Season year
game_type	VARCHAR(30)	Game classification, such as Regular Season or Playoffs
okc_score	INT	Oklahoma City score
opponent_score	INT	Opponent score

team_game_stats

Column	Type	Description
stat_idPK	INT	Unique team-game statistics identifier
game_id	INT	Referenced game identifier
team_abbreviation	VARCHAR(5)	Team abbreviation
three_pointers_made	INT	Three-point field goals made
three_pointers_attempted	INT	Three-point field goals attempted

Your question is Basketball Data Scenario Analysis. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem