Table: jack_ahearn_1954_norton
Columns: year
class
team
points
wins

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

Question: What is the most recent year for the ajs team when there are fewer than 0 wins?
SQL: SELECT MAX("year") FROM jack_ahearn_1954_norton WHERE "team" = 'ajs' AND "wins" < 0

Question: What is the smallest point amount for years prior to 1958 when the class is 350cc?
SQL: SELECT MIN("points") FROM jack_ahearn_1954_norton WHERE "year" < 1958 AND "class" = '350cc'

Question: What is the largest amount of wins when there are less than 5 points, the class is 500cc, the team is norton, and the year is more recent than 1955?
SQL: SELECT MAX("wins") FROM jack_ahearn_1954_norton WHERE "points" < 5 AND "class" = '500cc' AND "team" = 'norton' AND "year" > 1955