Your question is Repeat Support Issues by Customer. 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.
You are given support case data from athenaOne and need to identify customers who experienced the same issue more than once within a reporting period. Write a query that returns each customer and issue type combination with more than one matching case between 2024-01-01 and 2024-03-31, inclusive. Only include cases tied to a known customer and a non-null issue type, and return the customer name, issue type, and the number of times that issue occurred during the period.
| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer organization name |
| segment | VARCHAR(50) | Customer segment |
| go_live_date | DATE | Date the customer started using the platform |
| Column | Type | Description |
|---|---|---|
| case_idPK | INT | Unique support case identifier |
| customer_id | INT | Customer tied to the case |
| issue_type_id | INT | Issue category identifier |
| created_at | TIMESTAMP | Case creation timestamp |
| status | VARCHAR(30) | Current support case status |
| Column | Type | Description |
|---|---|---|
| issue_type_idPK | INT | Unique issue type identifier |
| issue_name | VARCHAR(100) | Issue category name |
| product_surface | VARCHAR(50) | athenahealth product surface |