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