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: Nomeie o ranking do aeroporto de Birmingham.
 ###Tabelas: CREATE TABLE list_of_countries_by_2010_emissions_estimates (list_of_countries_by_2010_emissions_estimates_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, CO2 emissions VARCHAR, Area (in km 2 ) INT, Population INT, Emission / Person INT) CREATE TABLE express_train_locomotives (express_train_locomotives_id AUTO_INCREMENT PRIMARY KEY, Class VARCHAR, Number range VARCHAR, Quantity VARCHAR, Year(s) Built VARCHAR, Type VARCHAR) CREATE TABLE 2007_data (2007_data_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Airport VARCHAR, Total Passengers INT, % Change 2006/2007 VARCHAR, International Passengers INT, Domestic Passengers INT, Transit Passengers INT, Aircraft Movements INT, Freight (Metric Tonnes) INT) CREATE TABLE torneo_apertura_"opening"_tournament (torneo_apertura_"opening"_tournament_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Points INT, Played INT, Drawn INT, Lost INT, Against INT, Diff INT) CREATE TABLE third_league (third_league_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Match INT, Points INT, Draw INT, Lost INT)  
SELECT MAX Rank FROM 2007_data WHERE Airport = Birmingham Airport