Creator Ticket Trend SQL | Dataford Interview Questions

Write a SQL query to analyze creator support ticket volume by region and week, and identify the top three regions with the largest week-over-week increase.

Use the provided creator region and support ticket tables. Compare each region with its immediately preceding calendar week.

Output

One row per region-week comparison, including only weeks with a prior calendar week.
Columns: region, week_start, current_ticket_volume, prior_ticket_volume, and week_over_week_increase.
Return the three largest increases, ordered by increase descending, then region ascending, then week ascending.

Schema

youtube_creator_support_tickets

Column	Type	Description
ticket_idPK	INT	Unique support ticket identifier
creator_id	INT	Creator associated with the ticket
created_at	DATE	Date the support ticket was created

creator_regions

Column	Type	Description
creator_idPK	INT	Unique creator identifier
region	VARCHAR(100)	Creator geographic region

Your question is Creator Ticket Trend SQL. 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