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 navios foram nomeados Carysfort?
 ###Tabelas: CREATE TABLE results_by_province (results_by_province_id AUTO_INCREMENT PRIMARY KEY, Province VARCHAR, Registered voters INT, People voted INT, Valid votes INT, Invalid votes INT, Yes INT, Yes (%) VARCHAR, No INT, No (%) VARCHAR, Turnout (%) VARCHAR) CREATE TABLE relief (relief_id AUTO_INCREMENT PRIMARY KEY, Table 2: Depression Data VARCHAR, 1929 INT, 1931 INT, 1933 INT, 1937 INT, 1938 INT, 1940 INT) CREATE TABLE marriage_statistics (marriage_statistics_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Marriages between men INT, Marriages between women INT, Same-sex marriages INT, Total marriages INT, % same-sex marriages VARCHAR) CREATE TABLE ships (ships_id AUTO_INCREMENT PRIMARY KEY, Ship VARCHAR, Laid down VARCHAR, Builder VARCHAR, Engine-builder VARCHAR, Launched VARCHAR, Completed VARCHAR, Disposition VARCHAR, Fate VARCHAR) CREATE TABLE newly_named_pterosaurs (newly_named_pterosaurs_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Status VARCHAR, Authors VARCHAR, Unit VARCHAR, Location VARCHAR)  
SELECT COUNT Completed FROM ships WHERE Ship = Carysfort