What is the status for tennis at cleveland state who has yes for swimming, golf and soccer?
CREATE TABLE table_name_78 (tennis VARCHAR, school VARCHAR, swimming VARCHAR, golf VARCHAR, soccer VARCHAR)
SELECT tennis FROM table_name_78 WHERE golf = "yes" AND soccer = "yes" AND swimming = "yes" AND school = "cleveland state"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_78 (tennis VARCHAR, school VARCHAR, swimming VARCHAR, golf VARCHAR, soccer VARCHAR) Question: What is the status for tennis at cleveland state who has yes for swimming, golf and soccer? [/INST] SELECT tennis FROM table_name_78 WHERE golf = "yes" AND soccer = "yes" AND swimming = "yes" AND school = "cleveland state" </s>