Table: race_results
Columns: result
date
race
venue
group
distance
weight_kg
time
jockey
winner_2nd

Question: Who was the winner when the time was 1:24.00?
SQL: SELECT "winner_2nd" FROM race_results WHERE "time" = '1:24.00'

Question: How many results were there for the Stan Fox Stakes race?
SQL: SELECT COUNT("result") FROM race_results WHERE "race" = 'Stan Fox Stakes'

Question: Was the rosehill venue a win or loss?
SQL: SELECT "result" FROM race_results WHERE "venue" = 'Rosehill'