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.

From the flight_reservations.sqlite database, display the following column:

• name — from the passengers table

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.