CREATE TABLE table_name_8 (wins NUMBER, points VARCHAR2, team VARCHAR2, year VARCHAR2)

What is the mean number of wins for the norton team in 1966, when there are 8 points?
SELECT AVG(wins) FROM table_name_8 WHERE team = "norton" AND year = 1966 AND points = 8
SELECT AVG("wins") FROM "table_name_8" WHERE "norton" = "team" AND "points" = 8 AND "year" = 1966