Find the names of all instructors in computer science department
SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'
names of all instructors refers to SELECT name; in computer science department refers to WHERE dept_name = 'Comp. Sci.';