SQL for Business Performance Metrics | Dataford Interview Questions

Write a SQL query to analyze business performance at Tripadvisor by joining bookings, users, and support tickets, then aggregate key metrics by month and region. Include bookings and users with matching records, while preserving regions that have no support tickets. Use the booking month for monthly reporting and count each support ticket once.

Output

One row per booking month and region, ordered by month ascending and region ascending.
Columns: month, region, booking_count, total_booking_value, unique_users, support_ticket_count, and users_with_tickets.
Include booking months and regions with zero support tickets.

Schema

users

Column	Type	Description
user_idPK	INT	Unique Tripadvisor user identifier
country_code	VARCHAR(2)	Two-letter user country code
region	VARCHAR(40)	Reporting region for the user

bookings

Column	Type	Description
booking_idPK	INT	Unique booking identifier
user_id	INT	User who made the booking
booked_at	DATE	Booking date
amount	NUMERIC(10,2)	Booking value

support_tickets

Column	Type	Description
ticket_idPK	INT	Unique support ticket identifier
user_id	INT	User who submitted the ticket
opened_at	DATE	Ticket creation date
status	VARCHAR(20)	Current ticket status

Your question is SQL for Business Performance Metrics. 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