Your question is Identify High-Ticket Inactive Customers. Start with the requirements and the three tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
At Autodesk, the support team wants to find customers who generated a high number of support tickets in May 2024 but did not log into Autodesk Fusion during that same month.
Write a SQL query to return customers who meet these conditions.
NULL.ticket_count_past_month descending, then last_login_at ascending with NULLS FIRST.| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer full name |
| account_status | VARCHAR(30) | Current account status |
| Column | Type | Description |
|---|---|---|
| ticket_idPK | INT | Unique support ticket identifier |
| customer_id | INT | Customer who submitted the ticket |
| product_name | VARCHAR(100) | Product associated with the ticket |
| submitted_at | TIMESTAMP | Ticket submission timestamp |
| issue_type | VARCHAR(50) | Support issue category |
| Column | Type | Description |
|---|---|---|
| login_idPK | INT | Unique login event identifier |
| customer_id | INT | Customer who logged in |
| product_name | VARCHAR(100) | Product used during login |
| login_at | TIMESTAMP | Login timestamp |
| device_type | VARCHAR(30) | Device used for login |