Table: motorcycle_race_results_2008_10
Columns: rider
manufacturer
laps
time
grid

Question: Who was the rider who had less than 30 laps, ended in an accident with a car manufactured by yamaha on a grid larger than 3?
SQL: SELECT "rider" FROM motorcycle_race_results_2008_10 WHERE "laps" < 30 AND "manufacturer" = 'yamaha' AND "time" = 'accident' AND "grid" > 3

Question: Who was the manufacturer for the race on grid 12?
SQL: SELECT "manufacturer" FROM motorcycle_race_results_2008_10 WHERE "grid" = 12

Question: Who was the manufacturer for the car that dani pedrosa did less than 9 laps in?
SQL: SELECT "manufacturer" FROM motorcycle_race_results_2008_10 WHERE "laps" < 9 AND "rider" = 'dani pedrosa'

Question: How many laps did the driver with the yamaha manufacturer go on grid 3?
SQL: SELECT "laps" FROM motorcycle_race_results_2008_10 WHERE "manufacturer" = 'yamaha' AND "grid" = 3