Table: race_results_2008_north
Columns: rank
rider
team
time
speed

Question: Who was the rider with 120.953 mph speed?
SQL: SELECT "rider" FROM race_results_2008_north WHERE "speed" = '120.953 mph'

Question: What time did rider steve plater have?
SQL: SELECT "time" FROM race_results_2008_north WHERE "rider" = 'steve plater'

Question: What is the rank of rider gary johnson, who had a speed of 120.979 mph?
SQL: SELECT "rank" FROM race_results_2008_north WHERE "speed" = '120.979 mph' AND "rider" = 'gary johnson'