List Passengers with No Reservations
Your supervisor wants to contact passengers who haven’t booked any flights yet, perhaps for a promotion or reminder campaign.
To identify these passengers, you’ll search for entries in the passengers table without corresponding reservations.
This is a classic case for using a LEFT JOIN with IS NULL — a powerful combination for finding unmatched records between tables.
What to Show
From the flight_reservations.sqlite database, display the following column:
name— from the passengers table
How to solve it
Use a LEFT JOIN to combine passengers with reservations on passenger_id, and filter for rows where reservation_id is NULL to show passengers who have no bookings.
Write a SQL query that returns only those passengers without any reservations.
Want to learn more?
Join CodeFriends Plus membership or enroll in a course to start your journey.