Qual era o objetivo médio de Thierry Henry quando o seu posto era superior a 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