CREATE TABLE table_name_32 (year NUMBER, charts VARCHAR2)

What year was the No. 7 charts?
SELECT AVG(year) FROM table_name_32 WHERE charts = "no. 7"
SELECT AVG("year") FROM "table_name_32" WHERE "charts" = "no. 7"