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: Determine a diferença nas horas de voo entre voos consecutivos para cada modelo de aeronave, particionado por fabricante.
 ###Tabelas: 
CREATE TABLE AircraftFlightHours (AircraftID INT, Model VARCHAR(50), Manufacturer VARCHAR(50), FlightHours INT, PreviousFlightHours INT); INSERT INTO AircraftFlightHours (AircraftID, Model, Manufacturer, FlightHours, PreviousFlightHours) VALUES (1, '747', 'Boeing', 55000, NULL); INSERT INTO AircraftFlightHours (AircraftID, Model, Manufacturer, FlightHours, PreviousFlightHours) VALUES (2, 'A320', 'Airbus', 35000, NULL); INSERT INTO AircraftFlightHours (AircraftID, Model, Manufacturer, FlightHours, PreviousFlightHours) VALUES (3, 'CRJ', 'Bombardier', 20000, NULL); INSERT INTO AircraftFlightHours (AircraftID, Model, Manufacturer, FlightHours, PreviousFlightHours) VALUES (4, '747', 'Boeing', 60000, 55000); INSERT INTO AircraftFlightHours (AircraftID, Model, Manufacturer, FlightHours, PreviousFlightHours) VALUES (5, 'A320', 'Airbus', 38000, 35000);
SELECT Model, Manufacturer, FlightHours, PreviousFlightHours, FlightHours - LAG(FlightHours) OVER (PARTITION BY Manufacturer ORDER BY FlightHours) AS Flight_Hour_Difference FROM AircraftFlightHours;