What is the id of the instructor who advises of all students from History department?
CREATE TABLE student (
    id VARCHAR,
    dept_name VARCHAR
)

CREATE TABLE advisor (
    s_id VARCHAR
)
SELECT i_id FROM advisor AS T1 JOIN student AS T2 ON T1.s_id = T2.id WHERE T2.dept_name = 'History'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the id of the instructor who advises of all students from History department? ### Input: CREATE TABLE student (
    id VARCHAR,
    dept_name VARCHAR
)

CREATE TABLE advisor (
    s_id VARCHAR
) ### Response: SELECT i_id FROM advisor AS T1 JOIN student AS T2 ON T1.s_id = T2.id WHERE T2.dept_name = 'History'