You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_1013168_2 (successor VARCHAR, date_of_successors_formal_installation VARCHAR)
system
Who was the succesor that was formally installed on November 8, 1978?
user
SELECT successor FROM table_1013168_2 WHERE date_of_successors_formal_installation = "November 8, 1978"
assistant
<|im_start|>system
You are an text to SQL query translator. Users will ask you questions in English and you will generate a SQL query based on the provided SCHEMA.
SCHEMA:
CREATE TABLE table_1013168_2 (successor VARCHAR, date_of_successors_formal_installation VARCHAR)<|im_end|>
<|im_start|>user
Who was the succesor that was formally installed on November 8, 1978?<|im_end|>
