Your question is SQL and Python Data Work. Start with the requirements and the two 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.
Tell me about your experience using SQL and Python to solve data analysis problems.
For the hands-on SQL portion, use the provided users and analytics_events tables to summarize valid January 2025 activity for every user. Return one row per user, including users without qualifying events, and sort by total event value descending and user ID ascending.
user_id, user_name, qualifying_event_count, conversion_count, total_event_value, latest_event_at| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| user_name | VARCHAR(100) | User display name |
| VARCHAR(255) | User email address |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event identifier |
| user_id | INT | User associated with the event |
| occurred_at | TIMESTAMP | Event timestamp |
| event_type | VARCHAR(50) | Type of analytics event |
| channel | VARCHAR(50) | Acquisition or interaction channel |
| event_value | DECIMAL(10,2) | Optional numeric value associated with the event |