course content

Course Content

Intermediate SQL

Challenge 1Challenge 1

Task

You have to join two tables: passenger and departure.

  1. Select surname_passenger and name_passenger from the passenger table;
  2. Select the departure_time column from the departure table;
  3. Join these two tables 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 6
toggle bottom row