Which manufacturer has more than 28 laps and less than 9 grids with jeremy mcwilliams?
CREATE TABLE "moto_gp_classification" (
  "rider" text,
  "manufacturer" text,
  "laps" real,
  "time_retired" text,
  "grid" real
);
SELECT "manufacturer" FROM "moto_gp_classification" WHERE "laps"<28 AND "grid"<9 AND "rider"='jeremy mcwilliams';