Which Title has Others of amstrad cpc, and a Genre of arcade?
CREATE TABLE "titles_by_beyond_software" (
  "title" text,
  "genre" text,
  "c_64" text,
  "zx_spectrum" text,
  "others" text,
  "year" real,
  "format" text
);
SELECT "title" FROM "titles_by_beyond_software" WHERE "others"='amstrad cpc' AND "genre"='arcade';