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

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