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 empates o treinador Francis Cummins teve com menos de 4 derrotas?
 ###Tabelas: CREATE TABLE season_summaries (season_summaries_id AUTO_INCREMENT PRIMARY KEY, Competition VARCHAR, Played INT, Drawn INT, Lost INT, Position VARCHAR, Coach VARCHAR, Captain VARCHAR, Main Article VARCHAR) CREATE TABLE composition_of_the_15th_seanad (composition_of_the_15th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE geography_and_environment (geography_and_environment_id AUTO_INCREMENT PRIMARY KEY, Island VARCHAR, Nickname VARCHAR, Area VARCHAR, Population (as of 2010) INT, Highest point VARCHAR, Elevation VARCHAR, Age ( Ma ) VARCHAR) CREATE TABLE station_repeaters (station_repeaters_id AUTO_INCREMENT PRIMARY KEY, Callsign VARCHAR, Network VARCHAR, City of License VARCHAR, D ERP VARCHAR, Owner / Operator VARCHAR) CREATE TABLE returning_this_year_after_a_break_of_one_year_or_longer (returning_this_year_after_a_break_of_one_year_or_longer_id AUTO_INCREMENT PRIMARY KEY, Programme VARCHAR, Date(s) of original removal VARCHAR, Original channel(s) VARCHAR, Date of return VARCHAR, New channel(s) VARCHAR)  
SELECT SUM Drawn FROM season_summaries WHERE Lost < 4 AND Coach = francis cummins