CUSTOMER Customer ID Passport_number Customer_name e_mail Customer phone Adress Country FREQUENT_FLYER_CUSTOMER Customer ID Passport_number Customer_name e_mail Customer_phone Adress Country...

Write 10 SELECT statements for the database you have implemented.
i. 3 of them should use minimum 2 tables.
ii. 4 of them should use minimum 3 tables.
iii. 3 of them should use minimum 4 tables.

Extracted text: CUSTOMER Customer ID Passport_number Customer_name e_mail Customer phone Adress Country FREQUENT_FLYER_CUSTOMER Customer ID Passport_number Customer_name e_mail Customer_phone Adress Country Frequent_flyer_number TICKET Ticket number Flight_number Leg_number Flight date Customer_ID Fare_amount Seat_number Flying_class CHECK_IN Ticket number Customer_ID Check_configuraiton TRANSACTION_RECORD Ticket number Flight number Leg number Customer ID


Extracted text: COMPANY Company name AIRLINE_COMPANY Сompany_name AIRPLANE_COMPANY Company name AIRPORT Airport code Airport_name City State FLIGHT Flight number Company_name Weekdays FLIGHT_LEG Flight number Leg number Departure_airport_code Arival_airport_code Scheduled_departure_time Scheduled_arrival_time Mileage LEG_INSTANCE Elight_number Leg number Elight date Departure_airport_code Arrival_airport_code Number_of_available_seats Airplane_ID Departure_time Arrival_time FARE Flight_number Fare code Amount Restrictions AIRPLANE Airplane ID Max_Seats Airplane type_name Company_name CAN LAND Airplane ID Airport code