human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: Week, Team, Carries, Yards, Average
###Question: Which Average has Yards larger than 167, and a Team of at tb, and a Week larger than 7?
gpt
SELECT MIN Average FROM table WHERE Yards > 167 AND Team = at tb AND Week > 7