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 modelos foram produzidos onde a planta é Castle Bromwich?
 ###Tabelas: CREATE TABLE gost_7.67-94 (gost_7.67-94_id AUTO_INCREMENT PRIMARY KEY, Country name VARCHAR, Russian name VARCHAR, Cyrillic code VARCHAR, Latin 3-letter code VARCHAR, Latin 2-letter code VARCHAR, Numeric code INT) CREATE TABLE current_teams (current_teams_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, District VARCHAR, Area/Province VARCHAR, Stadium VARCHAR, First Season VARCHAR, Last Title VARCHAR) CREATE TABLE assembly_plants (assembly_plants_id AUTO_INCREMENT PRIMARY KEY, Company VARCHAR, Parent company VARCHAR, Parent headquarters VARCHAR, Plant VARCHAR, Models produced VARCHAR, Production (latest figures) VARCHAR) CREATE TABLE singles_20–9 (singles_20–9_id AUTO_INCREMENT PRIMARY KEY, Edition VARCHAR, Round VARCHAR, Date VARCHAR, Surface VARCHAR, Opponent VARCHAR, Result VARCHAR) CREATE TABLE deficit_spending (deficit_spending_id AUTO_INCREMENT PRIMARY KEY, End of Fiscal Year INT, Gross Debt in $Billions undeflated Treas. INT, as % of GDP Low-High VARCHAR, Debt Held By Public ($Billions) INT, as % of GDP (Treas/MW, OMB or OMB/MW) INT, GDP $Billions OMB/BEA est.=MW.com VARCHAR)  
SELECT COUNT Models produced FROM assembly_plants WHERE Plant = Castle Bromwich