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_phone