CREATE TABLE table_name_73 (school VARCHAR2, indoor_track VARCHAR2, soccer VARCHAR2, tennis VARCHAR2)

Which school has yes for soccer, tennis and indoor track.
SELECT school FROM table_name_73 WHERE soccer = "yes" AND tennis = "yes" AND indoor_track = "yes"
SELECT "school" FROM "table_name_73" WHERE "indoor_track" = "yes" AND "soccer" = "yes" AND "tennis" = "yes"