Q5. Given sample data of table named: Flights, answer the following questions: (6' 3 points) Flight Capacity Date Assigned Plane Type Seats Reserved Seats Available 102 Boeing 727 41 424 250 329 DC9 11/12/97 11/12/97 11/12/97 11/14/97 165 248 440 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 507 Boeing 747 DC9 372 162 -12 68 60 102 248 DCO 248 230 15 329 507 329 11/15/97 11/15/97 DC 157 91 24 185 11/16/97 Boeing 727 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