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 é a perda com o clube sendo colwyn bay rfc
 ###Tabelas: CREATE TABLE 2007_2008_table (2007_2008_table_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Played VARCHAR, Won VARCHAR, Drawn VARCHAR, Lost VARCHAR, Points for VARCHAR, Points against VARCHAR, Tries for VARCHAR, Tries against VARCHAR, Try bonus VARCHAR, Losing bonus VARCHAR, Points VARCHAR) CREATE TABLE sapporo (sapporo_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Nationality VARCHAR, 1st (m) INT, 2nd (m) INT, Points INT, Overall WC points (Rank) VARCHAR) CREATE TABLE doubles:_6_4–2 (doubles:_6_4–2_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Year INT, Championship VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE legislative_elections (legislative_elections_id AUTO_INCREMENT PRIMARY KEY, Election INT, Total votes INT, Share of votes VARCHAR, Outcome of election VARCHAR, Election leader VARCHAR) CREATE TABLE nsc_events_and_division_1_winners (nsc_events_and_division_1_winners_id AUTO_INCREMENT PRIMARY KEY, Year INT, Winner VARCHAR, Location VARCHAR, Entrants INT, Winners Prize VARCHAR, Total Prize Pool VARCHAR)  
SELECT Lost FROM 2007_2008_table WHERE Club = Colwyn Bay RFC