Table: swimming_2007_3
Columns: rank
heat
lane
name
nationality

Question: How many heats had 5 lanes and a rank less than 110 for the nationality of Honduras?
SQL: SELECT COUNT("heat") FROM swimming_2007_3 WHERE "lane" = 5 AND "rank" > 110 AND "nationality" = 'honduras'

Question: How many heats had 2 lanes, a rank above 75, and nationality of Madagascar?
SQL: SELECT COUNT("heat") FROM swimming_2007_3 WHERE "lane" = 2 AND "rank" > 75 AND "nationality" = 'madagascar'

Question: What is the sum of every heat for the nationality of Macedonia with a rank less than 114?
SQL: SELECT SUM("heat") FROM swimming_2007_3 WHERE "nationality" = 'macedonia' AND "rank" < 114

Question: What was the least number of heats with more than 8 lanes for the Nationality of Germany?
SQL: SELECT MIN("heat") FROM swimming_2007_3 WHERE "nationality" = 'germany' AND "lane" > 8