DATABASE ORACLE SQL

On the given database, write a query that shows:

Airline, year and number of passengers.

Class A Passenger * passenger_id INT first_name VARCHAR2 last_name VARCHAR2 email VARCHAR2 date_of_birth DATE loyalty_id INT Booking * ticket_id INT flight_id INT seatNum VARCHAR2 class_id INT passeger_id INT class_id INT class_type VARCHAR2 Loyalty Airport * loyalty_id INT loyalty_type VARCHAR2 * airport_id INT location_id INT Flight Location LEDJO PILUA DATABASE PROJECT AIRLINE * flight_id INT departure_time TIME departure_date DATE status_id INT arrival_time TIME arrival_date DATE route_id INT Route * route_id INT airline_id INT departure_airport_id INT arrival_airport_id INT Status * location_id INT country_name VARCHAR2 city_name VARCHAR2 code VARCHAR2 * status_id INT status_name VARCHAR(45) Airline * airline_id INT airline_name VARCHAR2 Pilot *pilot_id INT first_name VARCHAR(45) last_name VARCHAR(45) experience INT Flight_Pilot flight_id INT pilot_id INT S airline_code VARCHAR2 location_id INT