What are the names of all the instructors?
select name from instructor
Of those, which are in the Comp. Sci. department?
select name from instructor where dept_name = 'Comp. sci.'