CREATE TABLE flight (
    flno NUMBER PRIMARY KEY,
    origin TEXT,
    destination TEXT,
    distance NUMBER,
    departure_date TIME,
    arrival_date TIME,
    price NUMBER,
    aid NUMBER,
    FOREIGN KEY ("aid") REFERENCES aircraft("aid")
);
CREATE TABLE aircraft (
    aid NUMBER PRIMARY KEY,
    name TEXT,
    distance NUMBER
);
CREATE TABLE employee (
    eid NUMBER PRIMARY KEY,
    name TEXT,
    salary NUMBER
);
CREATE TABLE certificate (
    eid NUMBER PRIMARY KEY,
    aid NUMBER,
    FOREIGN KEY ("aid") REFERENCES aircraft("aid"),
    FOREIGN KEY ("eid") REFERENCES employee("eid")
);

Question: How many aircrafts do we have?
SQL: SELECT count(*) FROM Aircraft

Question: How many aircrafts exist in the database?
SQL: SELECT count(*) FROM Aircraft

Question: Show name and distance for all aircrafts.
SQL: SELECT name ,  distance FROM Aircraft

Question: What are the names and distances for all airplanes?
SQL: SELECT name ,  distance FROM Aircraft

Question: Show ids for all aircrafts with more than 1000 distance.
SQL: SELECT aid FROM Aircraft WHERE distance  >  1000

Question: What are the ids of all aircrafts that can cover a distance of more than 1000?
SQL: SELECT aid FROM Aircraft WHERE distance  >  1000

Question: How many aircrafts have distance between 1000 and 5000?
SQL: SELECT count(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000

Question: What is the count of aircrafts that have a distance between 1000 and 5000?
SQL: SELECT count(*) FROM Aircraft WHERE distance BETWEEN 1000 AND 5000

Question: What is the name and distance for aircraft with id 12?
SQL: SELECT name ,  distance FROM Aircraft WHERE aid  =  12

Question: What is the name and distance for the aircraft that has an id of 12?
SQL: SELECT name ,  distance FROM Aircraft WHERE aid  =  12

Question: What is the minimum, average, and maximum distance of all aircrafts.
SQL: SELECT min(distance) ,  avg(distance) ,  max(distance) FROM Aircraft

Question: Return the minimum, average and maximum distances traveled across all aircrafts.
SQL: SELECT min(distance) ,  avg(distance) ,  max(distance) FROM Aircraft

Question: Show the id and name of the aircraft with the maximum distance.
SQL: SELECT aid ,  name FROM Aircraft ORDER BY distance DESC LIMIT 1

Question: What is the id and name of the aircraft that can cover the maximum distance?
SQL: SELECT aid ,  name FROM Aircraft ORDER BY distance DESC LIMIT 1

Question: Show the name of aircrafts with top three lowest distances.
SQL: SELECT name FROM Aircraft ORDER BY distance LIMIT 3

Question: What are the aircrafts with top 3 shortest lengthes? List their names.
SQL: SELECT name FROM Aircraft ORDER BY distance LIMIT 3

Question: Show names for all aircrafts with distances more than the average.
SQL: SELECT name FROM Aircraft WHERE distance  >  (SELECT avg(distance) FROM Aircraft)

Question: What are the names of all aircrafts that can cover more distances than average?
SQL: SELECT name FROM Aircraft WHERE distance  >  (SELECT avg(distance) FROM Aircraft)

Question: How many employees do we have?
SQL: SELECT count(*) FROM Employee

Question: What is the number of employees?
SQL: SELECT count(*) FROM Employee

Question: Show name and salary for all employees sorted by salary.
SQL: SELECT name ,  salary FROM Employee ORDER BY salary

Question: What is the name and salary of all employees in order of salary?
SQL: SELECT name ,  salary FROM Employee ORDER BY salary

Question: Show ids for all employees with at least 100000 salary.
SQL: SELECT eid FROM Employee WHERE salary  >  100000

Question: What is the id of every employee who has at least a salary of  100000?
SQL: SELECT eid FROM Employee WHERE salary  >  100000

Question: How many employees have salary between 100000 and 200000?
SQL: SELECT count(*) FROM Employee WHERE salary BETWEEN 100000 AND 200000

Question: What is the number of employees that have a salary between 100000 and 200000?
SQL: SELECT count(*) FROM Employee WHERE salary BETWEEN 100000 AND 200000

Question: What is the name and salary for employee with id 242518965?
SQL: SELECT name ,  salary FROM Employee WHERE eid  =  242518965

Question: What is the name and salary of the employee with the id 242518965?
SQL: SELECT name ,  salary FROM Employee WHERE eid  =  242518965

Question: What is average and maximum salary of all employees.
SQL: SELECT avg(salary) ,  max(salary) FROM Employee

Question: What is the average and largest salary of all employees?
SQL: SELECT avg(salary) ,  max(salary) FROM Employee

Question: Show the id and name of the employee with maximum salary.
SQL: SELECT eid ,  name FROM Employee ORDER BY salary DESC LIMIT 1

Question: What is the id and name of the employee with the highest salary?
SQL: SELECT eid ,  name FROM Employee ORDER BY salary DESC LIMIT 1

Question: Show the name of employees with three lowest salaries.
SQL: SELECT name FROM Employee ORDER BY salary ASC LIMIT 3

Question: What is the name of the 3 employees who get paid the least?
SQL: SELECT name FROM Employee ORDER BY salary ASC LIMIT 3

Question: Show names for all employees with salary more than the average.
SQL: SELECT name FROM Employee WHERE salary  >  (SELECT avg(salary) FROM Employee)

Question: What are the names of all employees who have a salary higher than average?
SQL: SELECT name FROM Employee WHERE salary  >  (SELECT avg(salary) FROM Employee)

Question: Show the id and salary of Mark Young.
SQL: SELECT eid ,  salary FROM Employee WHERE name  =  'Mark Young'

Question: What is the id and salary of the employee named Mark Young?
SQL: SELECT eid ,  salary FROM Employee WHERE name  =  'Mark Young'

Question: How many flights do we have?
SQL: SELECT count(*) FROM Flight

Question: What is the number of flights?
SQL: SELECT count(*) FROM Flight

Question: Show flight number, origin, destination of all flights in the alphabetical order of the departure cities.
SQL: SELECT flno ,  origin ,  destination FROM Flight ORDER BY origin

Question: What is the flight number, origin, and destination for all flights in alphabetical order by departure cities?
SQL: SELECT flno ,  origin ,  destination FROM Flight ORDER BY origin

Question: Show all flight number from Los Angeles.
SQL: SELECT flno FROM Flight WHERE origin  =  "Los Angeles"

Question: What are the numbers of all flights coming from Los Angeles?
SQL: SELECT flno FROM Flight WHERE origin  =  "Los Angeles"

Question: Show origins of all flights with destination Honolulu.
SQL: SELECT origin FROM Flight WHERE destination  =  "Honolulu"

Question: What are the origins of all flights that are headed to Honolulu?
SQL: SELECT origin FROM Flight WHERE destination  =  "Honolulu"

Question: Show me the departure date and arrival date for all flights from Los Angeles to Honolulu.
SQL: SELECT departure_date ,  arrival_date FROM Flight WHERE origin  =  "Los Angeles" AND destination  =  "Honolulu"

Question: What are the departure and arrival dates of all flights from LA to Honolulu?
SQL: SELECT departure_date ,  arrival_date FROM Flight WHERE origin  =  "Los Angeles" AND destination  =  "Honolulu"

Question: Show flight number for all flights with more than 2000 distance.
SQL: SELECT flno FROM Flight WHERE distance  >  2000

Question: What are the numbers of all flights that can cover a distance of more than 2000?
SQL: SELECT flno FROM Flight WHERE distance  >  2000

Question: What is the average price for flights from Los Angeles to Honolulu.
SQL: SELECT avg(price) FROM Flight WHERE origin  =  "Los Angeles" AND destination  =  "Honolulu"

Question: What is the average price for flights from LA to Honolulu?
SQL: SELECT avg(price) FROM Flight WHERE origin  =  "Los Angeles" AND destination  =  "Honolulu"

Question: Show origin and destination for flights with price higher than 300.
SQL: SELECT origin ,  destination FROM Flight WHERE price  >  300