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: Quantas equipes ganharam mais de 2 medalhas de prata e menos de 2 medalhas de bronze?
 ###Tabelas: CREATE TABLE category_leadership_table (category_leadership_table_id AUTO_INCREMENT PRIMARY KEY, Stage INT, Winner VARCHAR, General classification Żółta koszulka VARCHAR, Mountains classification Klasyfikacja górska VARCHAR, Intermediate Sprints Classification Klasyfikacja najaktywniejszych VARCHAR, Points classification Klasyfikacja punktowa VARCHAR, Teams classification VARCHAR) CREATE TABLE teams_and_drivers (teams_and_drivers_id AUTO_INCREMENT PRIMARY KEY, Entrant VARCHAR, Constructor VARCHAR, Chassis VARCHAR, Engine VARCHAR, Tyre VARCHAR, Driver VARCHAR, Rounds VARCHAR) CREATE TABLE medal_table_by_country (medal_table_by_country_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Nation VARCHAR, Gold INT, Silver INT, Bronze INT, Total INT) CREATE TABLE state_schools (state_schools_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Gender VARCHAR, Age Range VARCHAR, Religious Affiliation VARCHAR, Location VARCHAR, School website VARCHAR) CREATE TABLE list_of_elected_mps (list_of_elected_mps_id AUTO_INCREMENT PRIMARY KEY, Constituency VARCHAR, Winner VARCHAR, Party VARCHAR, Margin INT, Runner-up a VARCHAR, Party a VARCHAR)  
SELECT COUNT Rank FROM medal_table_by_country WHERE Silver > 2 AND Bronze < 2