q1
SELECT Flights.origin, Flights.destination
FROM Flights
WHERE DateDiff("h", departure, arrival) > 5

q2
SELECT abrand
FROM Aircrafts, Flights
WHERE origin='ord'
	AND destination='lga'
	AND Aircrafts.aid=Flights.aid

q3
SELECT ename
FROM Employees, Flights
WHERE salary<(50*price)
	AND origin='lax'
	AND destination='hnl'

q4
SELECT ename
FROM Employees, Aircrafts, Certified
WHERE Employees.empid=Certified.empid
	AND abrand='boeing'
	AND Aircrafts.aid=Certified.aid

q5
SELECT fltno
FROM Flights, Employees, Certified
WHERE salary>100000
	AND Flights.aid=Certified.aid
	AND Certified.empid=Employees.empid

q6
SELECT fltno
FROM Flights, Employees, Certified
WHERE salary>80000
	AND Flights.aid=Certified.aid
	AND Certified.empid=Employees.empid

q7
SELECT ename
FROM Employees, Certified, Aircrafts
WHERE Aircrafts.aid=Certified.aid
	AND Employees.empid=Certified.empid
	AND Aircrafts.acruisingrange>3000
	AND Employees.empid NOT IN (SELECT emp FROM Certified, Aircrafts WHERE Aircrafts.abrand='boeing' and Certified.aid=Aircrafts.aid)

q8
SELECT fltno, departure
FROM Flights
WHERE origin='ord'
	AND destination='lga'
	AND arrival<TimeValue("6:00PM")

q9
SELECT ename
FROM Employees
WHERE salary > (SELECT AVG(salary) FROM Employees)