1. List the total number of journeys done during October 2015.
2. List the company name of all available airplanes.
3. List the total number of airports in each country.
4. List flight number, departing airport name, arrival airport name, scheduled departure time, scheduled arrival time of all the flights that has France as their destination country.
5. List the total number of passengers that traveled on 25-09-2015.
6. List the total number of passengers from each nationality that travelled on the journey date between 11-10-2015 and 16-10-2015 of the flight number 227.
7. List journey date, flight number, departing airport name, arrival airport name, actual departure time, actual arrival time of all the journeys that departed or landed at Beirut International Airport.
8. List airplane code, number of seats, production year and airplane company of all airplanes produced after the year 2010.
9. List the average age of passengers who traveled to Lebanon in 2015.
10. List flight number, journey date, departing airport, actual departure time, arrival airport, actual arrival time of all flights that are done on airbus airplanes (company name = airbus) on 19-11-2015

Write 5 additional queries that you find useful for this application. The queries should not be easy.

Airline PK Airline id No.Of Seats Production_year Model PK Model_id Company FK Airline_id Flights PK Flight_number Dept_time Art_time Destination Schedule FK Airline_id Airport PK Airport_id Destination Name Country FK Flight_id Journey PK Date Dept_time Arr_time No. of Passenger Schedule FK Flight_id Seats PK Seat_number Occ_status Pass_name Nationality Age phone_number FK Flight_id