Table: swimming_2008_men_butterfly
Columns: rank
lane
name
nationality
time

Question: What nationality has a lane less than 6, with 1 as the rank?
SQL: SELECT "nationality" FROM swimming_2008_men_butterfly WHERE "lane" < 6 AND "rank" = 1

Question: What time has a lane less than 5, with Poland as the nationality?
SQL: SELECT "time" FROM swimming_2008_men_butterfly WHERE "lane" < 5 AND "nationality" = 'poland'

Question: How many lanes have 1:53.70 as the time?
SQL: SELECT COUNT("lane") FROM swimming_2008_men_butterfly WHERE "time" = '1:53.70'

Question: How many ranks have chen yin as the name, with a lane greater than 8?
SQL: SELECT SUM("rank") FROM swimming_2008_men_butterfly WHERE "name" = 'chen yin' AND "lane" > 8

Question: What nationality has 1:55.35 as the time?
SQL: SELECT "nationality" FROM swimming_2008_men_butterfly WHERE "time" = '1:55.35'

Question: How many lanes have a rank greater than 8?
SQL: SELECT SUM("lane") FROM swimming_2008_men_butterfly WHERE "rank" > 8