Table: swimming_2007_2
Columns: heat_rank
lane
swimmer
country
time
overall_rank

Question: Tell me the average heat rank with a lane of 2 and time less than 27.66
SQL: SELECT AVG("heat_rank") FROM swimming_2007_2 WHERE "lane" = 2 AND "time" < 27.66

Question: Tell me the highest overall rank for lane less than 8 and time less than 27.16
SQL: SELECT MAX("overall_rank") FROM swimming_2007_2 WHERE "lane" < 8 AND "time" < 27.16

Question: Tell me the total number of time for luke hall overall rank being larger than 105
SQL: SELECT COUNT("time") FROM swimming_2007_2 WHERE "swimmer" = 'luke hall' AND "overall_rank" > 105