BlueWave Cruises wants a daily summary of activity by ship and venue. Write a SQL query to aggregate booking data by day, ship, and venue.
booking_date, ship_name, and venue_name.booking_date is NULL.booking_date, then ship_name, then venue_name.| Column | Type | Description |
|---|---|---|
| booking_idPK | INT | Unique booking record ID |
| booking_date | DATE | Date the booking was made |
| ship_name | VARCHAR(100) | Name of the ship |
| venue_name | VARCHAR(100) | Name of the onboard venue |
| guest_count | INT | Number of guests in the booking |
| booking_status | VARCHAR(20) | Booking status such as confirmed, cancelled, or waitlist |