CREATE TABLE student (id VARCHAR2, dept_name VARCHAR2)
CREATE TABLE advisor (i_id VARCHAR2, s_id VARCHAR2)
CREATE TABLE instructor (name VARCHAR2, salary VARCHAR2, id VARCHAR2)

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" "T1" JOIN "instructor" "T2" ON "T1"."i_id" = "T2"."id" JOIN "student" "T3" ON "T1"."s_id" = "T3"."id" AND "T3"."dept_name" = 'History'