SELECT i_id FROM advisor AS T1 JOIN student AS T2 ON T1.s_id  =  T2.id WHERE T2.dept_name  =  'History'
What is the id of the instructor who advises of all students from History department?
SELECT i_id FROM advisor AS T1 JOIN student AS T2 ON T1.s_id = T2.id WHERE T2.dept_name = 'History '
select i_id from advisor as t1 join student as t2 on t1 . s_id = t2 . id where t2 . dept_name = value
What is the id of the instructor who advises of all students from History department ?