Question: I need help on this database SQL questions refer to the table given. Thank you 1) What is the least expensive flight number without restrictions.

I need help on this database SQL questions refer to the table given. Thank you

1) What is the least expensive flight number without restrictions. Show a single result using the appropriate math function (use Gamma operator).

2) Provide the names, departure airport, and arrival airport of the people you (YES YOU - use your first name) are flying with.

3) List the total number of available seats by flight number (regardless of date) Hint Need to use the gamma operator and appropriate math function.

4) 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

I need help on this database SQL questions refer to the table

AIRPORT Airport code Name City State FLIGHT Flight_number Airline Weekdays FLIGHT_LEG Flight number Leg_number Departure_airport_code Scheduled_departure_time 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_idTotal_number_of_seats Airplane_type SEAT RESERVATION Flight number Leg_number Date Seat_number Customer_nameCustomer_phone AIRPORT Airport code Name City State FLIGHT Flight_number Airline Weekdays FLIGHT_LEG Flight number Leg_number Departure_airport_code Scheduled_departure_time 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_idTotal_number_of_seats Airplane_type SEAT RESERVATION Flight number Leg_number Date Seat_number Customer_nameCustomer_phone

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!