What are the names of the instructors in the Comp. Sci. department who earn more than 80000?
SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'  AND salary  >  80000
names of the instructors = SELECT name; in the Comp. Sci. department refers to WHERE dept_name = 'Comp. Sci.'; who earn more than 80000 refers to AND salary > 80000;