Question
Write SQL statement to do the following: a) Using one statement insert the data of at least three customers into the SEAT_RESERVATION table. b) Increase
Write SQL statement to do the following: a) Using one statement insert the data of at least three customers into the SEAT_RESERVATION table.
b) Increase the AMOUNT of all FARES for passengers who fly KLM the 5%.
c) List the passengers onboard LT_575 whose destination is Kotoka International Airport.
d) Remove the record of the Airplane with the identification number BA_6789.
e) Report on all the passengers who booked a flight in the system
f) Display all the AIRPLANE _TYPES possessed by British Airways
g) Show the price list of all International Airlines
h) Give a discount of 10% on all fares to passengers who travel on British Airways.
i) Report on the flight leg for Airlines whose name is prefixed with K
j) Retrieve the sum, count and maximum of the available seats on the all airplanes that are due for departure between the hours of 9:00 am and 12:00 noon.
AIRPORT Airport_code Name City State FLIGHT Flight number Airline Weekdays FLIGHT_LEG Flight_number Leg_number Departure_airport_code Arrival airport code Scheduled departure_time 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 Airplano_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_phoneStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started