What is your experience with analyzing data, recognizing revenue leakages, and which Excel tools do you use?
For this SQL exercise, use the bookings and charges tables to identify booking-level revenue leakage. Include confirmed or completed bookings where expected revenue exceeds settled charges.
booking_id, sailing_date, expected_revenue, collected_revenue, revenue_leakage, and leakage_reason.revenue_leakage descending, then booking_id ascending.| Column | Type | Description |
|---|---|---|
| booking_idPK | INT | Unique booking identifier |
| sailing_date | DATE | Scheduled sailing date |
| expected_revenue | NUMERIC(12,2) | Revenue expected from the booking |
| booking_status | VARCHAR(20) | Current booking status |
| source_system | VARCHAR(30) | System that originated the booking |
| Column | Type | Description |
|---|---|---|
| charge_idPK | INT | Unique charge identifier |
| booking_id | INT | Booking associated with the charge |
| amount | NUMERIC(12,2) | Charge amount |
| charge_status | VARCHAR(20) | Processing status of the charge |
| charge_type | VARCHAR(20) | Type of booking charge |