Table: horse_race_2008
Columns: sp
number
horse
age
handicap_st_lb
jockey
trainer
owner
colours
finishing_position

Question: What horses does r. a. Scott own?
SQL: SELECT "horse" FROM horse_race_2008 WHERE "owner" = 'R. A. Scott'

Question: How many numbers have sp of 20/1 and a finishing position of fence 19?
SQL: SELECT COUNT("number") FROM horse_race_2008 WHERE "sp" = '20/1' AND "finishing_position" = 'Fence 19'

Question: Which handicap has the horse knowhere?
SQL: SELECT "handicap_st_lb" FROM horse_race_2008 WHERE "horse" = 'Knowhere'

Question: What colors does David Langdon use?
SQL: SELECT "colours" FROM horse_race_2008 WHERE "owner" = 'David Langdon'