Table: swimming_2008_women_100butterfly_2
Columns: rank
lane
name
nationality
time

Question: What is Lisbeth Trickett's time?
SQL: SELECT COUNT("time") FROM swimming_2008_women_100butterfly_2 WHERE "name" = 'lisbeth trickett'

Question: What is the average rank for 57.05 time?
SQL: SELECT AVG("rank") FROM swimming_2008_women_100butterfly_2 WHERE "time" < 57.05

Question: What lane is from Great Britain and a 57.78 time?
SQL: SELECT COUNT("lane") FROM swimming_2008_women_100butterfly_2 WHERE "nationality" = 'great britain' AND "time" > 57.78