Table: airport_traffic_4
Columns: rank
airport
total_passengers
change_2006_2007
international_passengers
domestic_passengers
transit_passengers
aircraft_movements
freight_metric_tonnes

Question: Name the rank of birmingham airport
SQL: SELECT MAX("rank") FROM airport_traffic_4 WHERE "airport" = 'Birmingham Airport'

Question: Name the transit passengers for 171078
SQL: SELECT MAX("transit_passengers") FROM airport_traffic_4 WHERE "freight_metric_tonnes" = 171078