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'
id of the instructor who advises all students from History department refers to a JOIN operation between advisor and student tables where student department is 'History';