Table: swimming_2008_men_100m
Columns: rank
lane
name
nationality
time

Question: What is the Rank of the Swimmer in Lane 5?
SQL: SELECT AVG("rank") FROM swimming_2008_men_100m WHERE "lane" = 5

Question: What is the Rank of the swimmer with a Time of 49 in Lane 7 or larger?
SQL: SELECT COUNT("rank") FROM swimming_2008_men_100m WHERE "time" = 49 AND "lane" > 7

Question: What is the Lane of the swimmer with a Rank of 8?
SQL: SELECT MAX("lane") FROM swimming_2008_men_100m WHERE "rank" = 8