Challenge: Find the Number of PassengerChallenge: Find the Number of Passenger

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