Find the names of all instructors in Comp. Sci. department with salary > 80000.
SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'  AND salary  >  80000
names of all instructors = SELECT name; in Comp. Sci. department refers to dept_name = 'Comp. Sci.'; with salary > 80000 refers to salary > 80000;