CREATE TABLE table_name_97 (chart_no NUMBER, date VARCHAR2)

What is the average chart number for 11/1965?
SELECT AVG(chart_no) FROM table_name_97 WHERE date = "11/1965"
SELECT AVG("chart_no") FROM "table_name_97" WHERE "11/1965" = "date"