Table: motorcycle_race_results_2002_2
Columns: rider
manufacturer
laps
time_retired
grid

Question: Which manufacturer has more than 28 laps and less than 9 grids with jeremy mcwilliams?
SQL: SELECT "manufacturer" FROM motorcycle_race_results_2002_2 WHERE "laps" < 28 AND "grid" < 9 AND "rider" = 'jeremy mcwilliams'

Question: What is the grid average with a +1 lap time and more than 27 laps?
SQL: SELECT AVG("grid") FROM motorcycle_race_results_2002_2 WHERE "time_retired" = '+1 lap' AND "laps" > 27

Question: Which lap has more than 17 grids with tetsuya harada?
SQL: SELECT "laps" FROM motorcycle_race_results_2002_2 WHERE "grid" > 17 AND "rider" = 'tetsuya harada'