Give me IDs of instructors in the Marketing department
select ID from instructor where dept_name = 'Marketing'
IDs of instructors = select ID; in the Marketing department refers to where dept_name = 'Marketing';