Company: Zoom | Difficulty: easy
Zoom's account-management team wants to identify large cloud recordings that may require additional storage planning.
Find all available recordings larger than 500 MB.
500
Return the columns in this exact order: meeting_id, host_email, file_size_mb, and recording_date.
meeting_id
host_email
file_size_mb
recording_date
Recordings exactly 500 MB should not be included. Sort the results by file_size_mb descending. If two recordings have the same size, sort by meeting_id ascending.
cloud_recordings
recording_id
recording_status
eric.yuan@zoom.us's recording (meeting 7001) is returned because it is available and larger than 500 MB. Meeting 7002 is excluded because its size is exactly 500 MB. Meeting 7003 is excluded because it is still processing. aparana.bawa@zoom.us's recording (meeting 7004) is returned because it is available and larger than 500 MB.
eric.yuan@zoom.us
7001
available
7002
7003
aparana.bawa@zoom.us
7004
DROP TABLE IF EXISTS cloud_recordings; CREATE TABLE cloud_recordings ( recording_id INT, meeting_id INT, host_email VARCHAR(120), file_size_mb DECIMAL(10,2), recording_date DATE, recording_status VARCHAR(20) ); INSERT INTO cloud_recordings VALUES (1, 7001, 'eric.yuan@zoom.us', 750.00, '2025-01-05', 'available'), (2, 7002, 'kelly.stecel@zoom.us', 500.00, '2025-01-06', 'available'), (3, 7003, 'ryan.azus@zoom.us', 900.00, '2025-01-07', 'processing'), (4, 7004, 'aparana.bawa@zoom.us', 600.00, '2025-01-08', 'available');
← All SQL Challenges · Zoom Questions · Learn SQL Free