CREATE TABLE table_name_17 (goals NUMBER, player VARCHAR2, rank VARCHAR2)

What was Thierry Henry's average goal when his rank was higher than 7?
SELECT AVG(goals) FROM table_name_17 WHERE player = "thierry henry" AND rank > 7
SELECT AVG("goals") FROM "table_name_17" WHERE "player" = "thierry henry" AND "rank" > 7