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 número total de vencedores secundários (Sul) se os vencedores primários (Sul) forem Mendip Gate?
 ###Tabelas: CREATE TABLE list_of_recent_lower_tier_county_cup_south_winners (list_of_recent_lower_tier_county_cup_south_winners_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Junior (South) Winners VARCHAR, Intermediate (South) Winners VARCHAR, Minor (South) Winners VARCHAR, Primary (South) Winners VARCHAR) CREATE TABLE semifinal_scores (semifinal_scores_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, Preliminary Average VARCHAR, Interview VARCHAR, Swimsuit VARCHAR, Evening Gown VARCHAR, Semifinal Average VARCHAR) CREATE TABLE election_results (election_results_id AUTO_INCREMENT PRIMARY KEY, Election INT, Candidates fielded INT, # of seats won INT, Total votes INT, % of popular vote VARCHAR, Place VARCHAR) CREATE TABLE series_3_2004 (series_3_2004_id AUTO_INCREMENT PRIMARY KEY, Celebrity VARCHAR, Famous for VARCHAR, Entered VARCHAR, Exited VARCHAR, Finished VARCHAR) CREATE TABLE season_6:_2005_2006 (season_6:_2005_2006_id AUTO_INCREMENT PRIMARY KEY, Series Ep. VARCHAR, Episode INT, Netflix VARCHAR, Segment A VARCHAR, Segment B VARCHAR, Segment C VARCHAR, Segment D VARCHAR)  
SELECT COUNT Minor (South) Winners FROM list_of_recent_lower_tier_county_cup_south_winners WHERE Primary (South) Winners = Mendip Gate