question: What was Thierry Henry's average goal when his rank was higher than 7?
answer: SELECT AVG(goals) FROM table_name_17 WHERE player = "thierry henry" AND rank > 7
context: CREATE TABLE table_name_17 (goals INTEGER, player VARCHAR, rank VARCHAR)