Q5. Given sample data of table named: Flights, answer the following questions: (6 x 3 points) Flight # Date Assigned Plane Type Capacity Seats Reserved Seats Available 102 11/12/97 165 124 41 329 11/12/97 248 260 -12 68 507 Destination Scheduled Departure Time Memphis 09:00 AM Los Angeles 09:10 PM Chicago 12:45 PM Memphis 09:00 AM Los Angeles 09:10 PM Chicago 12:45 PM Los Angeles 09:10 PM 440 11/12/97 11/14/97 372 102 Boeing 727 DC9 Boeing 747 DC9 DC9 DC9 Boeing 727 248 188 60 11/15/97 329 507 248 248 230 157 18 91 11/15/97 329 11/16/97 165 131 34 a. Write the syntax to create the table named: Flights. b. Write the syntax to insert new record with Flight = 554, Date = '28/12/2021, Destination = "Jedda", Scheduled_departure_time = "09:00 am", Assigned_plane_type = Boing 787, Seats_reserved = 101) c. Write the syntax to list: Flight number, plane type, available seats for flight going to Los Angeles ordered by seats reserved d. Show the output of (part c). e. Write the syntax to modify the Seats_available of flights going to Memphis on 14/11/97 to be 50. f. What is the Android java code that is used to execute question (e), assume the database is defined as myDBS