Table: swimming_2008_men_100
Columns: rank
heat
lane
name
nationality
time

Question: What is the nationality of the swimmer with a rank over 2 with a time of 55.77?
SQL: SELECT "nationality" FROM swimming_2008_men_100 WHERE "rank" > 2 AND "time" = '55.77'

Question: What is the earliest heat with a finisher from the Czech Republic and a rank over 41?
SQL: SELECT MIN("heat") FROM swimming_2008_men_100 WHERE "nationality" = 'czech republic' AND "rank" > 41

Question: What is the total number of heats with a finisher named Gregor Tait in lanes over 6?
SQL: SELECT COUNT("heat") FROM swimming_2008_men_100 WHERE "name" = 'gregor tait' AND "lane" > 6

Question: What is the time of the swimmer in rank 40?
SQL: SELECT "time" FROM swimming_2008_men_100 WHERE "rank" = 40