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: pergunta: quantas vezes o candidato phil crane (r) 58.0% edward a. warman (d) 42.0%?
 ###Tabelas: CREATE TABLE week_12 (week_12_id AUTO_INCREMENT PRIMARY KEY, Couple VARCHAR, Style VARCHAR, Music VARCHAR, Trine Dehli Cleve INT, Tor Fløysvik INT, Karianne Gulliksen INT, Christer Tornell INT, Total INT) CREATE TABLE  (_id AUTO_INCREMENT PRIMARY KEY, District VARCHAR, Incumbent VARCHAR, Party VARCHAR, First elected INT, Result VARCHAR, Candidates VARCHAR) CREATE TABLE leaders_in_the_northern_ireland_assembely (leaders_in_the_northern_ireland_assembely_id AUTO_INCREMENT PRIMARY KEY, Leader VARCHAR, Party VARCHAR, Leader's Seat VARCHAR, Number of Seats INT, Leader since VARCHAR) CREATE TABLE overall_results_in_clt20 (overall_results_in_clt20_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Matches VARCHAR, Wins VARCHAR, Losses VARCHAR, No Result VARCHAR, Success Rate VARCHAR) CREATE TABLE chinese_taipei_national_football_team (chinese_taipei_national_football_team_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Venue VARCHAR, Score VARCHAR, Competition VARCHAR, Report VARCHAR)  
SELECT COUNT Incumbent FROM  WHERE Candidates = Phil Crane (R) 58.0% Edward A. Warman (D) 42.0%