Find the name and salary of the instructors who are advisors of any student from History department?
SELECT T2.name ,  T2.salary FROM advisor AS T1 JOIN instructor AS T2 ON T1.i_id  =  T2.id JOIN student AS T3 ON T1.s_id  =  T3.id WHERE T3.dept_name  =  'History'
instructors who are advisors of any student from History department refers to a JOIN operation between instructor and student tables through an advisor table; advisor relationship is represented by matching instructor id (i_id) with instructor id (id) and student id (s_id) with student id (id); filtering students by department 'History' is done with WHERE condition on student dept_name = 'History';