Table: swimming_2008_men_100m_2
Columns: rank
lane
name
nationality
time

Question: how many times is the name matt targett and the lane higher than 7?
SQL: SELECT COUNT("time") FROM swimming_2008_men_100m_2 WHERE "name" = 'matt targett' AND "lane" > 7

Question: what is the highest time when the rank is less than 5 and the name is eamon sullivan?
SQL: SELECT MAX("time") FROM swimming_2008_men_100m_2 WHERE "rank" < 5 AND "name" = 'eamon sullivan'

Question: what is the average rank when the lane is more than 4 and the name is dominik meichtry?
SQL: SELECT AVG("rank") FROM swimming_2008_men_100m_2 WHERE "lane" > 4 AND "name" = 'dominik meichtry'