Table: manx_race_results_10
Columns: rank
rider
team
speed
time

Question: What is the Speed for Chris Swallow?
SQL: SELECT "speed" FROM manx_race_results_10 WHERE "rider" = 'chris swallow'

Question: What is the speed when the rank is larger than 2, and team is 500cc norton manx?
SQL: SELECT "speed" FROM manx_race_results_10 WHERE "rank" > 2 AND "team" = '500cc norton manx'

Question: What is the time for Alan Oversby?
SQL: SELECT "time" FROM manx_race_results_10 WHERE "rider" = 'alan oversby'

Question: What is the Speed when the rank is smaller than 3, and time is 1:06.19.90?
SQL: SELECT "speed" FROM manx_race_results_10 WHERE "rank" < 3 AND "time" = '1:06.19.90'

Question: What is the team when the time is 1:11.19.89?
SQL: SELECT "team" FROM manx_race_results_10 WHERE "time" = '1:11.19.89'