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 total de embarcações construídas em Wilmington, Califórnia?
 ###Tabelas: CREATE TABLE doubles_15 (doubles_15_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partnering VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE yearly_basis (yearly_basis_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Location VARCHAR, Number of teams VARCHAR, Player of the tournament VARCHAR, Top goalscorer(s) VARCHAR, Best goalkeeper VARCHAR) CREATE TABLE 1908-1994_-_new_south_wales_rugby_league (1908-1994_-_new_south_wales_rugby_league_id AUTO_INCREMENT PRIMARY KEY, Season INT, Grand FinalDate VARCHAR, WinningTeam VARCHAR, Score VARCHAR, LosingTeam VARCHAR, Location VARCHAR, GF Attendance INT, Clive Churchill Medal VARCHAR) CREATE TABLE shipyards_in_the_program (shipyards_in_the_program_id AUTO_INCREMENT PRIMARY KEY, Yard Name VARCHAR, Location (city, state) VARCHAR, 1st Ship Delivery Date VARCHAR, Total Number of Ways VARCHAR, total vessels built VARCHAR) CREATE TABLE regular_season_schedule (regular_season_schedule_id AUTO_INCREMENT PRIMARY KEY, Week INT, Date VARCHAR, Opponent VARCHAR, Result VARCHAR, Attendance INT)  
SELECT total vessels built FROM shipyards_in_the_program WHERE Location (city, state) = wilmington, california