Table: airlines_rankings
Columns: rank
airline
2012
2011
2010
2009

Question: avg passengers in 2012 for 2009 more than 104.5 and 2010 less than 162.6 and 2011 less than 141.8 is what?
SQL: SELECT AVG("2012") FROM airlines_rankings WHERE "2009" > 104.5 AND "2010" < 162.6 AND "2011" < 141.8

Question: The lowest rank with 2011 less than 80.7 and 2012 less than 73.1 is what?
SQL: SELECT MIN("rank") FROM airlines_rankings WHERE "2011" < 80.7 AND "2012" < 73.1

Question: the sum of 2009 with rank of 5 and 2010 less than 76.5 is what?
SQL: SELECT SUM("2009") FROM airlines_rankings WHERE "rank" = 5 AND "2010" < 76.5