Table: franco_bonera_350cc_harley
Columns: year
class
team
points
wins

Question: What is the average year that has a win less than 1, yamaha as the team, with points greater than 2?
SQL: SELECT AVG("year") FROM franco_bonera_350cc_harley WHERE "wins" < 1 AND "team" = 'yamaha' AND "points" > 2

Question: What is the highest wins that has 350cc as the class, yamaha for the team, with points less than 37, and a year after 1979?
SQL: SELECT MAX("wins") FROM franco_bonera_350cc_harley WHERE "class" = '350cc' AND "team" = 'yamaha' AND "points" < 37 AND "year" > 1979

Question: How many points have 500cc for the class, a win greater than 0, with a year after 1974?
SQL: SELECT SUM("points") FROM franco_bonera_350cc_harley WHERE "class" = '500cc' AND "wins" > 0 AND "year" > 1974

Question: How many wins have a year after 1976, and 350cc as the class?
SQL: SELECT SUM("wins") FROM franco_bonera_350cc_harley WHERE "year" > 1976 AND "class" = '350cc'