Table: werner_pfirter_1970
Columns: year
class
team
points
wins

Question: Count the average Wins which has a Class of 250cc, and a Year of 1972?
SQL: SELECT AVG("wins") FROM werner_pfirter_1970 WHERE "class" = '250cc' AND "year" = 1972

Question: Name the lowest Wins which has Points of 28, and a Year smaller than 1972?
SQL: SELECT MIN("wins") FROM werner_pfirter_1970 WHERE "points" = 28 AND "year" < 1972

Question: Name the Team which has Points larger than 9, and a Year larger than 1971, and a Class of 250cc?
SQL: SELECT "team" FROM werner_pfirter_1970 WHERE "points" > 9 AND "year" > 1971 AND "class" = '250cc'

Question: Name the Wins which has a Class of 350cc, and a Year smaller than 1973?
SQL: SELECT SUM("wins") FROM werner_pfirter_1970 WHERE "class" = '350cc' AND "year" < 1973

Question: How many Points has Wins larger than 0?
SQL: SELECT COUNT("points") FROM werner_pfirter_1970 WHERE "wins" > 0