Table: swimming_2008_womens_400im
Columns: heat
lane
name
nationality
time

Question: Who is from south korea and has a heat less than 3?
SQL: SELECT "name" FROM swimming_2008_womens_400im WHERE "heat" < 3 AND "nationality" = 'south korea'

Question: What is the highest heat of the athlete from spain with a lane less than 7?
SQL: SELECT MAX("heat") FROM swimming_2008_womens_400im WHERE "nationality" = 'spain' AND "lane" < 7

Question: What is the average lane of the athlete from japan with a time of 4:37.35 and a heat less than 3?
SQL: SELECT AVG("lane") FROM swimming_2008_womens_400im WHERE "nationality" = 'japan' AND "time" = '4:37.35' AND "heat" < 3