human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Sport, League, Tier, Club, Stadium
###Question: Which tier is for football at Tianhe Stadium?
gpt
SELECT Tier FROM table WHERE Sport = football AND Stadium = tianhe stadium