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 eleições resultaram em aposentados democratas mantendo-se no cargo?
 ###Tabelas: CREATE TABLE discography_-_original_releases (discography_-_original_releases_id AUTO_INCREMENT PRIMARY KEY, Year INT, Song (s) VARCHAR, Producer (s) VARCHAR, Written By VARCHAR, Artist VARCHAR, Title/Label VARCHAR) CREATE TABLE new_york (new_york_id AUTO_INCREMENT PRIMARY KEY, District VARCHAR, Incumbent VARCHAR, Party VARCHAR, First elected VARCHAR, Results VARCHAR, Candidates VARCHAR) CREATE TABLE highest_partnerships_for_each_wicket (highest_partnerships_for_each_wicket_id AUTO_INCREMENT PRIMARY KEY, Wicket VARCHAR, Runs VARCHAR, Partnerships VARCHAR, Venue VARCHAR, Date VARCHAR) CREATE TABLE current_clubs_2014_season (current_clubs_2014_season_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Position in 2013 VARCHAR, First season INT, First season of current spell INT, Number of seasons in Superettan INT, Number of seasons in second tier VARCHAR) CREATE TABLE michigan_65_ohio_normal_0 (michigan_65_ohio_normal_0_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Position VARCHAR, Starter VARCHAR, Touchdowns INT, Extra points INT, Field goals INT, Points INT)  
SELECT COUNT Party FROM new_york WHERE Results = Retired Democratic hold