Table: swimming_2000_womens_100m_4
Columns: rank
lane
name
nationality
time

Question: Which nationaly is ranked greater than 1, with a time of 59.75?
SQL: SELECT "nationality" FROM swimming_2000_womens_100m_4 WHERE "rank" > 1 AND "time" = '59.75'

Question: Which france nationality has a lane larger than 3?
SQL: SELECT "name" FROM swimming_2000_womens_100m_4 WHERE "lane" > 3 AND "nationality" = 'france'

Question: What's the total rank of the lane smaller than 8 with a time of 59.80?
SQL: SELECT SUM("rank") FROM swimming_2000_womens_100m_4 WHERE "time" = '59.80' AND "lane" < 8

Question: What's the top rank that's lane is smaller than 1?
SQL: SELECT MAX("rank") FROM swimming_2000_womens_100m_4 WHERE "lane" < 1