What horses does r. a. Scott own?
CREATE TABLE "competitors_and_betting" (
  "sp" text,
  "number" real,
  "horse" text,
  "age" real,
  "handicap_st_lb" text,
  "jockey" text,
  "trainer" text,
  "owner" text,
  "colours" text,
  "finishing_position" text
);
SELECT "horse" FROM "competitors_and_betting" WHERE "owner"='R. A. Scott';