CREATE TABLE aircraft (aid DECIMAL, name TEXT, distance DECIMAL)
CREATE TABLE employee (eid DECIMAL, name TEXT, salary DECIMAL)
CREATE TABLE flight (flno DECIMAL, origin TEXT, destination TEXT, distance DECIMAL, departure_date TIME, arrival_date TIME, price DECIMAL, aid DECIMAL)
CREATE TABLE certificate (eid DECIMAL, aid DECIMAL)

What are the names of all employees who have a salary higher than average?
SELECT name FROM employee WHERE salary > (SELECT AVG(salary) FROM employee)
SELECT "name" FROM "employee" WHERE "salary" > (SELECT AVG("salary") FROM "employee")