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 tipo de navio entregue quando a localização é Panama City, Flórida?
 ###Tabelas: CREATE TABLE ncrna_gene_prediction_software (ncrna_gene_prediction_software_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Number of sequences Number of sequences: . VARCHAR, Alignment Alignment: predicts an alignment , . VARCHAR, Structure Structure: predicts structure , . VARCHAR, Link VARCHAR) CREATE TABLE medal_standings (medal_standings_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Nation VARCHAR, Gold INT, Silver INT, Bronze INT, Total INT) CREATE TABLE second_round (second_round_id AUTO_INCREMENT PRIMARY KEY, Match No. VARCHAR, Home Team VARCHAR, Score VARCHAR, Away Team VARCHAR, Attendance VARCHAR) CREATE TABLE symptoms (symptoms_id AUTO_INCREMENT PRIMARY KEY, Condition VARCHAR, Prothrombin time VARCHAR, Partial thromboplastin time VARCHAR, Bleeding time VARCHAR, Platelet count 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, Ship Types Delivered VARCHAR, Total Number of Ways VARCHAR, Total Vessels Built for USMC VARCHAR)  
SELECT Ship Types Delivered FROM shipyards_in_the_program WHERE Location (City, State) = panama city, florida