Table: race_results_8
Columns: year
entrant
chassis
engine
points

Question: How many points after 1956?
SQL: SELECT COUNT("points") FROM race_results_8 WHERE "year" > 1956

Question: Before 1956, what Chassis has Gordini Straight-4 engine with 3 points?
SQL: SELECT "chassis" FROM race_results_8 WHERE "year" < 1956 AND "engine" = 'gordini straight-4' AND "points" = 3

Question: What engine was used by Equipe Simca Gordini before 1956 with less than 4 points?
SQL: SELECT "engine" FROM race_results_8 WHERE "year" < 1956 AND "points" < 4 AND "entrant" = 'equipe simca gordini'

Question: What chassis has smaller than 9 points by Equipe Rosier?
SQL: SELECT "chassis" FROM race_results_8 WHERE "points" < 9 AND "entrant" = 'equipe rosier'