CREATE TABLE table_name_43 (club VARCHAR, sport VARCHAR, venue VARCHAR)

Which club had football at Mitchel Athletic Field?
SELECT club FROM table_name_43 WHERE sport = "football" AND venue = "mitchel athletic field"
SELECT "club" FROM "table_name_43" WHERE "football" = "sport" AND "mitchel athletic field" = "venue"