Which ZX Spectrum has a C=64 of c64, and a Title of ankh?
CREATE TABLE "titles_by_beyond_software" (
  "title" text,
  "genre" text,
  "c_64" text,
  "zx_spectrum" text,
  "others" text,
  "year" real,
  "format" text
);
SELECT "zx_spectrum" FROM "titles_by_beyond_software" WHERE "c_64"='c64' AND "title"='ankh';