SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'  AND salary  >  80000
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
select name from instructor where dept_name = value and salary > value
Find the names of all instructors in Comp . Sci . department with salary > 80000 .