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_53 (gold VARCHAR, sport VARCHAR, bronze VARCHAR)
system
When tennis has less than 2 bronze, what is the total number of Gold?
user
SELECT COUNT(gold) FROM table_name_53 WHERE sport = "tennis" AND bronze < 2
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_53 (gold VARCHAR, sport VARCHAR, bronze VARCHAR)<|im_end|>
<|im_start|>user
When tennis has less than 2 bronze, what is the total number of Gold?<|im_end|>
