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 ranking de adam gilchrist
 ###Tabelas: CREATE TABLE most_caps (most_caps_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Player VARCHAR, Nation VARCHAR, Caps INT, Goals INT, Years VARCHAR) CREATE TABLE doubles:_9_6_titles_–_3_runner-ups (doubles:_9_6_titles_–_3_runner-ups_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE closed_and_aborted_television_providers (closed_and_aborted_television_providers_id AUTO_INCREMENT PRIMARY KEY, Provider VARCHAR, Years VARCHAR, Free or pay VARCHAR, No. of channels VARCHAR, Colour VARCHAR, Digital VARCHAR, Transmission VARCHAR) CREATE TABLE mig_credits (mig_credits_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Pilot VARCHAR, Weapon Systems Officer VARCHAR, Aircraft VARCHAR, Tail Code VARCHAR, Call Sign VARCHAR, Kill VARCHAR) CREATE TABLE most_dismissals_in_test_career_wicketkeeper (most_dismissals_in_test_career_wicketkeeper_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Dismissals INT, Player VARCHAR, Caught INT, Stumped INT, Matches INT, Innings INT)  
SELECT COUNT Rank FROM most_dismissals_in_test_career_wicketkeeper WHERE Player = Adam Gilchrist