Table: cosworth_results
Columns: year
entrant
chassis
engine
tyres
points

Question: Which engine of Rob Walker Racing Team has 47 points and F tyres?
SQL: SELECT "engine" FROM cosworth_results WHERE "points" = '47' AND "tyres" = 'f' AND "entrant" = 'rob walker racing team'

Question: Which entrant has 49 points and a Mclaren M7A chassis?
SQL: SELECT "entrant" FROM cosworth_results WHERE "points" = '49' AND "chassis" = 'mclaren m7a'

Question: How many points did Bob Gerard Racing have in 1965?
SQL: SELECT "points" FROM cosworth_results WHERE "entrant" = 'bob gerard racing' AND "year" = 1965

Question: Which entrant had a Brabham BT10 chassis before 1965?
SQL: SELECT "entrant" FROM cosworth_results WHERE "year" < 1965 AND "chassis" = 'brabham bt10'