Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
All Flights Information Challenge | Joining Tables
course content

Course Content

Intermediate SQL

All Flights Information ChallengeAll Flights Information Challenge

Task

You have to join two tables: departure and flights.

  1. Select departure_date, and departure_time from the departure table;
  2. Select start_point_flight, end_point_flight, travel_time from flights table;
  3. Join these two tables using the JOIN statement by flight_number column;
  4. Order your results by travel_time column in ascending order;
  5. Take the first 5 rows.

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 flights table:

flight_numberstart_point_flightend_point_flighttravel_time
1ParisNew York8
2ChicagoNew Delhi15
3New YorkDubai12
4Los AngelesHonolulu5

Everything was clear?

Section 3. Chapter 2
toggle bottom row
course content

Course Content

Intermediate SQL

All Flights Information ChallengeAll Flights Information Challenge

Task

You have to join two tables: departure and flights.

  1. Select departure_date, and departure_time from the departure table;
  2. Select start_point_flight, end_point_flight, travel_time from flights table;
  3. Join these two tables using the JOIN statement by flight_number column;
  4. Order your results by travel_time column in ascending order;
  5. Take the first 5 rows.

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 flights table:

flight_numberstart_point_flightend_point_flighttravel_time
1ParisNew York8
2ChicagoNew Delhi15
3New YorkDubai12
4Los AngelesHonolulu5

Everything was clear?

Section 3. Chapter 2
toggle bottom row
some-alt