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 é o número de eventos de inovação militar pelos EUA, Rússia e China de 2016 a 2018?
 ###Tabelas: 
CREATE TABLE military_innovation (country VARCHAR(50), year INT, event VARCHAR(50)); INSERT INTO military_innovation (country, year, event) VALUES ('USA', 2016, 'DARPA Robotics Challenge'); INSERT INTO military_innovation (country, year, event) VALUES ('USA', 2017, 'Hypersonic Weapon Test'); INSERT INTO military_innovation (country, year, event) VALUES ('USA', 2018, 'Laser Weapon Test'); INSERT INTO military_innovation (country, year, event) VALUES ('Russia', 2016, 'New Tank Prototype'); INSERT INTO military_innovation (country, year, event) VALUES ('Russia', 2017, 'Stealth Drone Test'); INSERT INTO military_innovation (country, year, event) VALUES ('Russia', 2018, 'New Submarine Launch'); INSERT INTO military_innovation (country, year, event) VALUES ('China', 2016, 'Carrier-based Jet Test'); INSERT INTO military_innovation (country, year, event) VALUES ('China', 2017, 'Artificial Intelligence Program'); INSERT INTO military_innovation (country, year, event) VALUES ('China', 2018, 'New Missile System Test');
SELECT country, COUNT(event) as total_events FROM military_innovation WHERE (country = 'USA' OR country = 'Russia' OR country = 'China') AND (year BETWEEN 2016 AND 2018) GROUP BY country;