Exercise 5.3 The following relations keep track of airline flight information: Flights(flno: integer, from: string, to: string, distance: integer, departs: time, arrives: time, price: real) Aircraft (aid: integer, aname: string, cruisingrange: integer) Certified(eid: integer, aid: integer) Employees(eid: integer, ename: string, salary: integer) Note that the Employees relation describes pilots and other kinds of employees as well; every pilot is certified for some aircraft, and only pilots are certified to fly. Write each of the following queries in SQL. (Additional queries using the same schema are listed in the exercises for Chapter 4.) 1. Find the names of aircraft such that all pilots certified to operate them have salaries more than $80,000. 2. For each pilot who is certified for more than three aircraft, find the eid and the maximum cruisingrange of the aircraft for which she or he is certified. 3. Find the names of pilots whose salary is less than the price of the cheapest route from Los Angeles to Honolulu.

I need the references for the answers

PYTHON / DATA ORGANIZATION Import the following reaction mechanism for syngas production from the course repository data/syngas-short-rxn.txt, keep the order of the reactions the same, and display the reactions.The reaction mechanism is given below kindly write code assuming its to be extracted. # Corrected ChatGPT##   Pyrolysis (Destruction of Feedstock):C(s) -> C(g)#   Primary Oxidation (Partial Combustion):2 C(g) + O2 -> 2 CO#   Secondary Oxidation (Complete Combustion):CO + 0.5 O2 -> CO2#   Methanation:C(g) + H2O -> CO + H2#   Shift Methane Reaction (Methane Decomposition):CH4 <=> C(g) + 2 H2