Schema: CREATE TABLE employee (fname VARCHAR, lname VARCHAR, salary INTEGER)
Question: Return the first names and last names of employees who earn more than 30000 in salary.
SQL: SELECT fname, lname FROM employee WHERE salary > 30000