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 total de pernas perdidas do jogador com um alto checkout inferior a 76 e menos de 3 jogados?
 ###Tabelas: CREATE TABLE connecting_lines (connecting_lines_id AUTO_INCREMENT PRIMARY KEY, Line Name VARCHAR, Date Closed VARCHAR, NIMT Junction VARCHAR, Terminus VARCHAR, Length VARCHAR) CREATE TABLE doubles_runner-ups_6 (doubles_runner-ups_6_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partnering VARCHAR, Opponents in the final VARCHAR, Score VARCHAR) CREATE TABLE statistics (statistics_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Played INT, Legs Won INT, Legs Lost INT, 100+ INT, 140+ INT, 180s INT, High Checkout INT, 3-dart Average INT) CREATE TABLE by (by_id AUTO_INCREMENT PRIMARY KEY, Parish VARCHAR, Obama% VARCHAR, Obama# INT, McCain% VARCHAR, McCain# INT) CREATE TABLE racial_composition (racial_composition_id AUTO_INCREMENT PRIMARY KEY, Municipality (2010) VARCHAR, White (both Hispanic and Non-Hispanic) INT, Black (Both Hispanic and Non-Hispanic) INT, Amerindian (Both Hispanic and Non-Hispanic) INT, n Asia (Both Hispanic and Non-Hispanic) INT, Multiracial (Both Hispanic and Non-Hispanic) INT, Hispanic (Of any Race) INT)  
SELECT COUNT Legs Lost FROM statistics WHERE High Checkout < 76 AND Played < 3