Your question is SQL Difficulty Check. Start with the requirements and the one table 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.
Netflix Open Connect telemetry records bandwidth consumed during streaming sessions. Write a PostgreSQL query that summarizes valid January 2025 usage for each subscriber.
bandwidth_mb is NULL.| Column | Type | Description |
|---|---|---|
| usage_idPK | INT | Unique streaming usage record |
| subscriber_id | INT | Netflix subscriber identifier |
| usage_date | DATE | Date of the streaming session |
| bandwidth_mb | DECIMAL(10,2) | Bandwidth consumed during the session in megabytes |