SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'  AND salary  >  80000
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
select name from instructor where dept_name = value and salary > value
What are the names of the instructors in the Comp . Sci . department who earn more than 80000 ?