CREATE TABLE employee (fname CLOB, minit CLOB, lname CLOB, ssn NUMBER, bdate CLOB, address CLOB, sex CLOB, salary NUMBER, super_ssn NUMBER, dno NUMBER)
CREATE TABLE dept_locations (dnumber NUMBER, dlocation CLOB)
CREATE TABLE project (pname CLOB, pnumber NUMBER, plocation CLOB, dnum NUMBER)
CREATE TABLE dependent (essn NUMBER, dependent_name CLOB, sex CLOB, bdate CLOB, relationship CLOB)
CREATE TABLE works_on (essn NUMBER, pno NUMBER, hours NUMBER)
CREATE TABLE department (dname CLOB, dnumber NUMBER, mgr_ssn NUMBER, mgr_start_date CLOB)

Return the first names and last names of employees who earn more than 30000 in salary.
SELECT fname, lname FROM employee WHERE salary > 30000
SELECT "fname", "lname" FROM "employee" WHERE "salary" > 30000