Table: sports_clubs
Columns: sport
league
tier
club
stadium

Question: Which stadium is for football with the China League One?
SQL: SELECT "stadium" FROM sports_clubs WHERE "sport" = 'football' AND "league" = 'china league one'

Question: Which tier is for football at Tianhe Stadium?
SQL: SELECT "tier" FROM sports_clubs WHERE "sport" = 'football' AND "stadium" = 'tianhe stadium'