course content

Course Content

Intermediate SQL

Challenge: Information about Passenger Flight DepartureChallenge: Information about Passenger Flight Departure

Task

You have to join two tables: departure and passenger.

  1. Select surname_passenger, and name_passenger from passenger table;
  2. Select departure_date from the departure table;
  3. Join these two tables using the JOIN statement by the number_of_departure column.

Here's a short example of the departure table:

number_of_departureflight_numberdeparture_datedeparture_time
132022-07-1608:00:00
212022-07-1813:15:00
............
632022-07-1608:00:00

Here's a short example of the passenger table:

idnumber_of_departurename_passengersurname_passenger
15LiamSmith
25OliviaJohnson
............
185OliviaJohnson

Everything was clear?

Section 3. Chapter 3
toggle bottom row