Table: cyclist_performance
Columns: rank
year
ascent_time
speed
rider

Question: What was the rank of the rider whose ascent time was 43:24 before the year 2002?
SQL: SELECT COUNT("rank") FROM cyclist_performance WHERE "year" < 2002 AND "ascent_time" = '43:24'

Question: Who is the rider that has a rank of less than 8 in the year 2000, and whose speed was 18.32 km/h?
SQL: SELECT "rider" FROM cyclist_performance WHERE "rank" < 8 AND "year" = 2000 AND "speed" = '18.32 km/h'