Recording Count
ASKED IN INTERVIEWZoom
Problem Statement
Zoom provides cloud storage for meeting recordings. To help account administrators manage their storage limits, you need to provide a summary of how many recordings exist for a particular account.
Write an SQL query to find the total number of cloud recordings for account_id 450.
Rules:
- Only count recordings where account_id is 450.
- Output columns: account_id, total_recordings.
- Results should be returned in descending order of total_recordings.
Table Schema:
- CloudRecordings: recording_id, account_id, meeting_id, file_size_mb, recording_start (TIMESTAMP).
Tests your understanding of
Basic SQL, Aggregation and Filtering
Input Tables
CloudRecordings
| recording_id(INTEGER) | account_id(INTEGER) | file_size_mb(DECIMAL) |
|---|---|---|
| 5001 | 450 | 120.5 |
| 5002 | 450 | 45 |
| 5003 | 451 | 300.2 |
| 5004 | 450 | 88 |
| 5005 | 452 | 15.5 |
| 5006 | 450 | 210 |
| 5007 | 450 | 5 |
Expected Output
| account_id(INTEGER) | total_recordings(INTEGER) |
|---|---|
| 450 | 5 |
Tags
EasyASKED IN INTERVIEWBasic SQLAggregationFiltering
5 min
95%