Database: college_2
Question: What are the names of the instructors in the Comp. Sci. department who earn more than 80000?
SQL:
SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'  AND salary  >  80000