Table: ferrari_results
Columns: year
entrant
chassis
engine
points

Question: what is the engine for year less than 1959 and points more than 4?
SQL: SELECT "engine" FROM ferrari_results WHERE "year" < 1959 AND "points" > 4

Question: what is the least year for 4 points?
SQL: SELECT MIN("year") FROM ferrari_results WHERE "points" = 4

Question: what is the entrant for the ferrari v8 with points less than 4?
SQL: SELECT "entrant" FROM ferrari_results WHERE "engine" = 'ferrari v8' AND "points" < 4

Question: what is the average year for 0 points and ferrari v8?
SQL: SELECT AVG("year") FROM ferrari_results WHERE "points" = 0 AND "engine" = 'ferrari v8'