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. Return the columns in this exact order: `meeting_id`, `host_email`, `file_size_mb`, and `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` descending. ### Table Schema | Table | Column | Type | |---|---|---| | `cloud_recordings` | `recording_id` | integer | | `cloud_recordings` | `meeting_id` | integer | | `cloud_recordings` | `host_email` | varchar(120) | | `cloud_recordings` | `file_size_mb` | decimal(10,2) | | `cloud_recordings` | `recording_date` | date | | `cloud_recordings` | `recording_status` | varchar(20) | ### Example Input: `cloud_recordings` | recording_id | meeting_id | host_email | file_size_mb | recording_date | recording_status | |---:|---:|---|---:|---|---| | 1 | 7001 | host1@example.com | 750.00 | 2025-01-05 | available | | 2 | 7002 | host2@example.com | 500.00 | 2025-01-06 | available | | 3 | 7003 | host3@example.com | 900.00 | 2025-01-07 | processing | | 4 | 7004 | host4@example.com | 600.00 | 2025-01-08 | available | ### Example Output Explanation The recording for 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. Meeting 7004 is returned because it is available and larger than 500 MB.
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,'host1@example.com',750.00,'2025-01-05','available'), (2,7002,'host2@example.com',500.00,'2025-01-06','available'), (3,7003,'host3@example.com',900.00,'2025-01-07','processing'), (4,7004,'host4@example.com',600.00,'2025-01-08','available');