Table: manx_race_results_4
Columns: rank
rider
team
speed
time

Question: What is Ryan McCay's speed that has a rank better than 8?
SQL: SELECT "speed" FROM manx_race_results_4 WHERE "rank" > 8 AND "rider" = 'ryan mccay'

Question: What's the name of the team that went 113.316mph?
SQL: SELECT "team" FROM manx_race_results_4 WHERE "speed" = '113.316mph'

Question: What's Matts Nilsson's team that's ranked better than 7?
SQL: SELECT "team" FROM manx_race_results_4 WHERE "rank" < 7 AND "rider" = 'matts nilsson'