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'
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 '
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 = value
Find the name and salary of the instructors who are advisors of any student from History department ?