What was Thierry Henry's average goal when his rank was higher than 7?
CREATE TABLE table_name_17 (goals INTEGER, player VARCHAR, rank VARCHAR)
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) ### 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