SELECT name FROM instructor WHERE dept_name  =  'Comp. Sci.'
Find the names of all instructors in computer science department
SELECT name FROM instructor WHERE dept_name = 'Comp . Sci . '
select name from instructor where dept_name = value
Find the names of all instructors in computer science department