In which department Mr. Mird work for?
SELECT dept_name FROM instructor where name  =  'Mird'
department Mr. Mird works for refers to dept_name; Mr. Mird's name as a condition for search is name = 'Mird';