Show the airport name, city, state and date of all flights that are not on a weekday.

List all airplane types that can land at any airport in Las-Vegas

List the name and phone number of all customers with a seat reserved on a flight that leaves Stockton airport (SCK) on January 28, 2018.

Hint Use the date function for your comparison date('2018-01-28') and use the reservation date

List all airlines that operate at Los Angeles International Airport (LAX)

Hint Use a union on the flight leg relation between departing and arriving flights

AIRPORT Airport_code Name City State FLIGHT Flight_number Airline Weekdays FLIGHT_LEG Flight_number Scheduled_departure_time Leg_number Departure_airport_code Arrival_airport_code Scheduled_arrival_time LEG_INSTANCE Flight_number Leg_number Date Number_of_available_seats Airplane_id Departure_airport_code Departure_time Arrival_airport_code Arrival_time FARE Flight_number Fare_code Amount Restrictions AIRPLANE_TYPE Airplane_type_name Max_seats Company CAN_LAND Airplane_type_name Airport_code AIRPLANE Airplane_id Total_number_of_seats Airplane_type SEAT_RESERVATION Flight_number Leg_number Date Seat_number Customer_name Customer_phone AIRPORT Airport_code Name City State FLIGHT Flight_number Airline Weekdays FLIGHT_LEG Flight_number Scheduled_departure_time Leg_number Departure_airport_code Arrival_airport_code Scheduled_arrival_time LEG_INSTANCE Flight_number Leg_number Date Number_of_available_seats Airplane_id Departure_airport_code Departure_time Arrival_airport_code Arrival_time FARE Flight_number Fare_code Amount Restrictions AIRPLANE_TYPE Airplane_type_name Max_seats Company CAN_LAND Airplane_type_name Airport_code AIRPLANE Airplane_id Total_number_of_seats Airplane_type SEAT_RESERVATION Flight_number Leg_number Date Seat_number Customer_name Customer_phone