Robinhood
Analytics Reporting Track · Medium · 25 min
Backlog Older Than Three Days
Operations wants to compare teams based on how often tickets stay unresolved for more than three days. Return team_name, total_tickets, aged_tickets, and age...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a Robinhood-tagged business scenario.
Approach
Use this track to train on SQL that mirrors day-to-day analytics workflows and recurring reporting asks.
Company context
Company labels are directional practice context, not official interview guidance.
Operations wants to compare teams based on how often tickets stay unresolved for more than three days. Return team_name, total_tickets, aged_tickets, and aged_ticket_pct rounded to two decimals. A ticket is aged if resolved_at is null or more than three days after created_at. Sort by team_name.
support_tickets
| ticket_id | team_name | ||
|---|---|---|---|
| 1 | Onboarding | 2024-09-01 | 2024-09-02 |
| 2 | Onboarding | 2024-09-03 | 2024-09-08 |
| 3 | Trading | 2024-09-02 | NULL |
| 4 | Trading | 2024-09-04 | 2024-09-05 |
| 5 | Fraud | 2024-09-01 | 2024-09-06 |
| 6 | Fraud | 2024-09-03 | 2024-09-04 |
SQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.