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_73 (club VARCHAR, founded VARCHAR, sport VARCHAR)
system
Name the Club which has a Founded larger than 1875, and a Sport of football?
user
SELECT club FROM table_name_73 WHERE founded > 1875 AND sport = "football"
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_73 (club VARCHAR, founded VARCHAR, sport VARCHAR)<|im_end|>
<|im_start|>user
Name the Club which has a Founded larger than 1875, and a Sport of football?<|im_end|>
