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_name_71 (date_of_inauguration VARCHAR)
system
What was the date of the inauguration in the row with an entry of lifespan in the lifespan column?
user
SELECT date_of_inauguration FROM table_name_71 WHERE "lifespan" = "lifespan"
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_name_71 (date_of_inauguration VARCHAR)<|im_end|>
<|im_start|>user
What was the date of the inauguration in the row with an entry of lifespan in the lifespan column?<|im_end|>
