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: Quantos anos John Player Lotus usou o Cosworth v8?
 ###Tabelas: CREATE TABLE complete_formula_one_results (complete_formula_one_results_id AUTO_INCREMENT PRIMARY KEY, Year INT, Entrant VARCHAR, Chassis VARCHAR, Engine VARCHAR, Points INT) CREATE TABLE season_1_2007 (season_1_2007_id AUTO_INCREMENT PRIMARY KEY, Series no. INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original air date VARCHAR, Production Code INT) CREATE TABLE twenty20_internationals (twenty20_internationals_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Wkts INT, Runs INT, Econ INT, Ovrs INT) CREATE TABLE kawerau_district (kawerau_district_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Years VARCHAR, Gender VARCHAR, Area VARCHAR, Authority VARCHAR, Decile INT) CREATE TABLE leading_copper-producing_mines (leading_copper-producing_mines_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Mine VARCHAR, County and State VARCHAR, Operator VARCHAR, Source of copper VARCHAR, Capacity (thousands of metric tons) INT)  
SELECT SUM Year FROM complete_formula_one_results WHERE Engine = cosworth v8 AND Entrant = john player lotus