Table: iom_tt_results
Columns: rank
rider
team
speed
time

Question: Who has a Rank larger than 3 with a speed of 119.838mph?
SQL: SELECT "rider" FROM iom_tt_results WHERE "rank" > 3 AND "speed" = '119.838mph'

Question: Which Team has a Time of 1:14.51.73?
SQL: SELECT "team" FROM iom_tt_results WHERE "time" = '1:14.51.73'

Question: Which Speed has a Rank smaller than 9 in kawasaki zx6 600cc Team?
SQL: SELECT "speed" FROM iom_tt_results WHERE "rank" < 9 AND "team" = 'kawasaki zx6 600cc'

Question: WHich Speed has a Rank of 2?
SQL: SELECT "speed" FROM iom_tt_results WHERE "rank" = 2