Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Qual fabricante possui mais de 28 voltas e menos de 9 grids com Jeremy McWilliams?
 ###Tabelas: CREATE TABLE césar_awards (césar_awards_id AUTO_INCREMENT PRIMARY KEY, Year INT, Group VARCHAR, Award VARCHAR, Film VARCHAR, Result VARCHAR) CREATE TABLE fc_bayern_munich_ii_versus_spvgg_unterhaching (fc_bayern_munich_ii_versus_spvgg_unterhaching_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, League VARCHAR, Teams VARCHAR, Home VARCHAR, Away VARCHAR) CREATE TABLE current_and_former_player_information (current_and_former_player_information_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Total W-L VARCHAR, Singles W-L VARCHAR, Doubles W-L VARCHAR, No. of ties INT, First year played INT, No. of years played INT) CREATE TABLE motogp_classification (motogp_classification_id AUTO_INCREMENT PRIMARY KEY, Rider VARCHAR, Manufacturer VARCHAR, Laps INT, Time/Retired VARCHAR, Grid INT) CREATE TABLE current_fleet (current_fleet_id AUTO_INCREMENT PRIMARY KEY, Length (feet) VARCHAR, Year VARCHAR, Make and model VARCHAR, Floor type VARCHAR, Number of seats INT, Bicycle capacity† INT, Fuel propulsion VARCHAR, Quantity INT)  
SELECT Manufacturer FROM motogp_classification WHERE Laps < 28 AND Grid < 9 AND Rider = jeremy mcwilliams