SpaceX's launch operations team wants to review Falcon launch performance throughout 2024. For each month and launch site in 2024, calculate the total number of launches, the number of successful launches, the success rate, and the total payload successfully delivered to orbit. A launch is successful only when `status = 'success'`. Failed and partial launches should still count toward the total number of launches but should not contribute to successful-launch counts or delivered payload. Treat a NULL payload as zero when calculating delivered payload. Return the columns in this exact order: `launch_year`, `launch_month`, `launch_site`, `total_launches`, `successful_launches`, `success_rate`, and `payload_delivered_tons`. Round `success_rate` to four decimal places and `payload_delivered_tons` to two decimal places. Sort by `launch_year` descending, `launch_month` descending, and `launch_site` descending. ### Table Schema | Table | Column | Type | |---|---|---| | `space_launches` | `launch_id` | integer | | `space_launches` | `launch_name` | varchar(80) | | `space_launches` | `launch_site` | varchar(40) | | `space_launches` | `launch_date` | date | | `space_launches` | `status` | varchar(20) | | `space_launches` | `payload_tons` | decimal(10,2) | ### Example Input: `space_launches` | launch_id | launch_name | launch_site | launch_date | status | payload_tons | |---:|---|---|---|---|---:| | 1 | Starlink Group 1 | Florida | 2024-01-12 | success | 15.20 | | 2 | Transporter 10 | California | 2024-01-20 | success | 12.00 | | 3 | CRS Mission 1 | Florida | 2024-01-25 | failure | 8.50 | | 4 | Starlink Group 2 | Florida | 2024-02-10 | success | 16.00 | | 5 | Test Flight | Texas | 2024-02-15 | partial | NULL | ### Example Output Explanation Florida had two January launches, but only one was successful, so its success rate is 0.5000 and its delivered payload is 15.20 tons. California had one successful January launch, while the February Texas launch was partial and contributed no delivered payload.
DROP TABLE IF EXISTS space_launches; CREATE TABLE space_launches ( launch_id INT, launch_name VARCHAR(80), launch_site VARCHAR(40), launch_date DATE, status VARCHAR(20), payload_tons DECIMAL(10,2) ); INSERT INTO space_launches VALUES (1,'Starlink Group 1','Florida','2024-01-12','success',15.20), (2,'Transporter 10','California','2024-01-20','success',12.00), (3,'CRS Mission 1','Florida','2024-01-25','failure',8.50), (4,'Starlink Group 2','Florida','2024-02-10','success',16.00), (5,'Test Flight','Texas','2024-02-15','partial',NULL);