Query and Prepare Data | Dataford Interview Questions

How would you manipulate and query a dataset in Python or R to prepare it for analysis?

For this PostgreSQL exercise, express the preparation as a SQL query using the provided tables. Return one analysis-ready row per regular-season game from January 1 through March 31, 2025.

Output

Columns: game_date, opponent, venue_name, attendance, tickets_sold, ticket_revenue, avg_ticket_price, and occupancy_status
Include games without matching venue or ticket records, using zero or NULL where appropriate
Sort by game_date ascending

Schema

games

Column	Type	Description
game_idPK	INT	Unique game identifier
game_date	DATE	Date of the game
opponent	VARCHAR(100)	Opponent name
venue_id	INT	Referenced venue identifier
attendance	INT	Recorded attendance
game_type	VARCHAR(30)	Season or competition classification

venues

Column	Type	Description
venue_idPK	INT	Unique venue identifier
venue_name	VARCHAR(150)	Venue name
capacity	INT	Maximum venue capacity

ticket_sales

Column	Type	Description
sale_idPK	INT	Unique ticket sale record
game_id	INT	Referenced game identifier
tickets_sold	INT	Tickets sold in the record
revenue	DECIMAL(12,2)	Revenue generated by the sale record

Your question is Query and Prepare Data. Start with the requirements and the three 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