SQL Aggregation Across Tables | Dataford Interview Questions

Write a SQL query to aggregate user data from multiple tables for Disney Experiences.

Return one row for each active user, combining reservation and park-entry activity. Include users without matching reservations or park-entry events, count only confirmed or completed reservations, and treat missing monetary values as zero.

Output

Columns: user_id, user_name, reservation_count, total_spend, park_entry_count, and last_park_entry
One row per active user
Sort by total_spend descending, then user_id ascending

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name
status	VARCHAR(20)	User account status

reservations

Column	Type	Description
reservation_idPK	INT	Unique reservation identifier
user_id	INT	User who made the reservation
status	VARCHAR(20)	Reservation lifecycle status
amount	DECIMAL(10,2)	Reservation amount

visit_events

Column	Type	Description
event_idPK	INT	Unique visit event identifier
user_id	INT	User associated with the event
event_type	VARCHAR(30)	Type of visit event
event_date	DATE	Date of the event

Your question is SQL Aggregation Across Tables. 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