Solve Problems with SQL | Dataford Interview Questions

Describe a time you used SQL to solve a complex business problem for a gaming or digital product team.

For this exercise, demonstrate the analysis with the provided gaming product data. Return the latest available calendar month, including games with no activity or revenue in that month.

Output

One row per game, with game_id, game_title, genre, active_players, play_minutes, revenue, revenue_rank, and latest_month
Include every game, use zero for missing activity or revenue, and rank revenue within each genre with ties sharing a rank
Order by genre, descending revenue, then game_title

Schema

games

Column	Type	Description
game_idPK	INT	Unique game identifier
game_title	VARCHAR(120)	Game title
genre	VARCHAR(40)	Primary game genre

player_sessions

Column	Type	Description
session_idPK	INT	Unique gameplay session identifier
game_id	INT	Game played during the session
player_id	INT	Player associated with the session
session_date	DATE	Date of the gameplay session
play_minutes	INT	Minutes played during the session

purchases

Column	Type	Description
purchase_idPK	INT	Unique purchase identifier
game_id	INT	Game associated with the purchase
player_id	INT	Player who made the purchase
purchase_date	DATE	Date of the purchase
amount	NUMERIC(10,2)	Purchase revenue

Your question is Solve Problems with SQL. 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