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...

According to tables below, write 3 SELECT statements to exemplify LEFT, RIGHT and FULL OUTER JOIN statements.

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


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