CREATE TABLE table_name_62 (tier VARCHAR2, sport VARCHAR2, stadium VARCHAR2)

Which tier is for football at Tianhe Stadium?
SELECT tier FROM table_name_62 WHERE sport = "football" AND stadium = "tianhe stadium"
SELECT "tier" FROM "table_name_62" WHERE "football" = "sport" AND "stadium" = "tianhe stadium"