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: Que tipos de navios foram feitos no estaleiro Froemming Brothers?
 ###Tabelas: CREATE TABLE pairs (pairs_id AUTO_INCREMENT PRIMARY KEY, Rank INT, WS Points INT, Name VARCHAR, Country VARCHAR, 08-09 I/O best INT, 08-09 GP/JGP best INT, 08-09 GP/JGP 2nd INT, 08-09 OI best INT, 08-09 OI 2nd INT, 07-08 I/O best INT, 07-08 GP/JGP best INT, 07-08 GP/JGP 2nd INT, 07-08 OI best INT, 07-08 OI 2nd INT) CREATE TABLE all-time_results_record (all-time_results_record_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, First Played INT, Played INT, Win INT, Draw INT, Loss INT, Points For INT, Ponts Against INT, Last Meeting INT) CREATE TABLE past_prize_winners (past_prize_winners_id AUTO_INCREMENT PRIMARY KEY, Year INT, First VARCHAR, Second VARCHAR, Third VARCHAR, Fourth 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) CREATE TABLE series_7_2013 (series_7_2013_id AUTO_INCREMENT PRIMARY KEY, Episode VARCHAR, Date VARCHAR, Official ITV rating (millions) VARCHAR, Weekly rank INT, Share (%) VARCHAR, Official ITV HD rating (millions) VARCHAR, Total ITV viewers (millions) VARCHAR)  
SELECT Ship Types Delivered FROM shipyards_in_the_program WHERE Yard Name = froemming brothers