What are the names of all instructors in the Comp. Sci. department?
SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'
names of all instructors in the Comp. Sci. department refers to SELECT name FROM instructor WHERE dept_name = 'Comp. Sci.';