Which school has yes for soccer, tennis and indoor track.
CREATE TABLE table_name_73 (school VARCHAR, indoor_track VARCHAR, soccer VARCHAR, tennis VARCHAR)
SELECT school FROM table_name_73 WHERE soccer = "yes" AND tennis = "yes" AND indoor_track = "yes"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_73 (school VARCHAR, indoor_track VARCHAR, soccer VARCHAR, tennis VARCHAR) Question: Which school has yes for soccer, tennis and indoor track. [/INST] SELECT school FROM table_name_73 WHERE soccer = "yes" AND tennis = "yes" AND indoor_track = "yes" </s>