Table: manx_race_results_7
Columns: rank
rider
team
speed
time

Question: What teams rank is higher than 4 with a speed of 104.574mph?
SQL: SELECT "team" FROM manx_race_results_7 WHERE "rank" > 4 AND "speed" = '104.574mph'

Question: What team does Anthony Redmond ride for?
SQL: SELECT "team" FROM manx_race_results_7 WHERE "rider" = 'anthony redmond'

Question: What was the speed with a time of 1:03.41.86 and a rank smaller than 3?
SQL: SELECT "speed" FROM manx_race_results_7 WHERE "rank" < 3 AND "time" = '1:03.41.86'