Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions

Question

4. What action should Cherita Howard take and why?

Answered: 1 week ago