Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Find the Number of Passenger Challenge | Joining Tables
Intermediate SQL

Find the Number of Passenger ChallengeFind the Number of Passenger Challenge

Task

  1. You need to find the number of passengers on each departure date;
  2. For it you have to join two tables: departure and passenger;
  3. Use the name_passenger column from the passenger table and the departure_date column from departure;
  4. Join these two tables by the number_of_departure column;
  5. Make grouping using the GROUP BY clause by the departure_date column from the departure table.

Here's a short example of the passenger table:

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

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

Everything was clear?

Section 3. Chapter 4
toggle bottom row
course content

Course Content

Intermediate SQL

Find the Number of Passenger ChallengeFind the Number of Passenger Challenge

Task

  1. You need to find the number of passengers on each departure date;
  2. For it you have to join two tables: departure and passenger;
  3. Use the name_passenger column from the passenger table and the departure_date column from departure;
  4. Join these two tables by the number_of_departure column;
  5. Make grouping using the GROUP BY clause by the departure_date column from the departure table.

Here's a short example of the passenger table:

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

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

Everything was clear?

Section 3. Chapter 4
toggle bottom row
some-alt