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: Quanto Total tem Semidoubles menores que 78 e Doubles, II Classe menores que 17?
 ###Tabelas: CREATE TABLE marine_ecozones (marine_ecozones_id AUTO_INCREMENT PRIMARY KEY, Ecozone VARCHAR, Area (km²) Territorial waters INT, Area (km²) Exclusive Economic Zone INT, Percentage of total area (forEEZ) INT, Percentage of marine area (forEEZ) INT) CREATE TABLE world_energy_intensity_progression_by_year. (world_energy_intensity_progression_by_year._id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, Unit p koe/$05 VARCHAR, 2006 INT, 2007 INT, 2008 INT, 2009 INT) CREATE TABLE percentage_pole_positions (percentage_pole_positions_id AUTO_INCREMENT PRIMARY KEY, Driver VARCHAR, Seasons VARCHAR, Entries INT, Poles INT, Percentage VARCHAR) CREATE TABLE week_eight (week_eight_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Time VARCHAR, Visiting team VARCHAR, Home team VARCHAR, Site VARCHAR, Broadcast VARCHAR, Result VARCHAR, Attendance INT) CREATE TABLE feast_days (feast_days_id AUTO_INCREMENT PRIMARY KEY, Date INT, Doubles, I Class INT, Doubles, II Class INT, Greater Doubles INT, Doubles INT, Semidoubles INT, Total INT)  
SELECT COUNT Total FROM feast_days WHERE Semidoubles < 78 AND Doubles, II Class < 17