List the airline for which fare is more than 3000. List the airport names which are arrival ports for atleast 3 flights. Retrieve airport code that is greater than all airplane id of given airplane type. List the flight number that has no booking
AIRPORT(Airport_code ,Name,City,State)
FLIGHT(Flight_number, Airline,Weekdays)
FLIGHT_LEG(Flight_number,Leg_number,Scheduled_departure_time,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)
List the airline for which fare is more than 3000.
List the airport names which are arrival ports for atleast 3 flights.
Retrieve airport code that is greater than all airplane id of given airplane type.
List the flight number that has no booking
Step by step
Solved in 2 steps
