Your question is Daily Ship Venue Booking Totals. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
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 |