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

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")