Table: swimming_2007_world_aquatics
Columns: rank
heat_lane
name
nationality
time

Question: What Nationality has a Time of 9:01.70?
SQL: SELECT "nationality" FROM swimming_2007_world_aquatics WHERE "time" = '9:01.70'

Question: What is sun yang's lowest rank?
SQL: SELECT MIN("rank") FROM swimming_2007_world_aquatics WHERE "name" = 'sun yang'

Question: What is the rank for Heat : Lane of 4 : 1?
SQL: SELECT "rank" FROM swimming_2007_world_aquatics WHERE "heat_lane" = '4 : 1'

Question: How many ranks have a ationality of canada, and a Time of dns?
SQL: SELECT COUNT("rank") FROM swimming_2007_world_aquatics WHERE "nationality" = 'canada' AND "time" = 'dns'