Table: pironi_race_stats
Columns: year
entrant
chassis
engine
points

Question: Which year averaged less than 9 points?
SQL: SELECT AVG("year") FROM pironi_race_stats WHERE "points" < 9

Question: What is the total points of teams using a ligier js11/15 chassis?
SQL: SELECT COUNT("points") FROM pironi_race_stats WHERE "chassis" = 'ligier js11/15'

Question: What is the highest year team tyrrell earned more than 14 points?
SQL: SELECT MAX("year") FROM pironi_race_stats WHERE "entrant" = 'team tyrrell' AND "points" > 14