Database: college_2
Question: What are the names of all instructors in the Comp. Sci. department?
SQL:
SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'