Skip to main content
Practice

Join Flights with Passengers

The reservations team needs a complete list of upcoming flights, including the passenger names associated with each booking.

Your job is to generate a report that joins passenger information with flight reservation details.

To do this, you'll use an INNER JOIN to combine records from two related tables: passengers and reservations.

This kind of join is a core operation in SQL, especially when working across multiple datasets.


What to Show​

From the flight_reservations.sqlite database, display:

  • name (from the passengers table)
  • flight_code
  • departure_date

Use INNER JOIN to combine data from the passengers and reservations tables using the shared passenger_id.


Task​

Write a SQL query that joins passengers with reservations to show each passenger's name, their flight code, and the departure date.

Only include rows where a reservation exists (use INNER JOIN).

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.