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.

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.

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).