Database: college_2
Question: Find the names of all instructors in Comp. Sci. department with salary > 80000.
SQL:
SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'  AND salary  >  80000