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_78 (tennis VARCHAR, school VARCHAR, swimming VARCHAR, golf VARCHAR, soccer VARCHAR)
system
What is the status for tennis at cleveland state who has yes for swimming, golf and soccer?
user
SELECT tennis FROM table_name_78 WHERE golf = "yes" AND soccer = "yes" AND swimming = "yes" AND school = "cleveland state"
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_78 (tennis VARCHAR, school VARCHAR, swimming VARCHAR, golf VARCHAR, soccer VARCHAR)<|im_end|>
<|im_start|>user
What is the status for tennis at cleveland state who has yes for swimming, golf and soccer?<|im_end|>
