CREATE TABLE table_name_7 (zx_spectrum VARCHAR2, c64 VARCHAR2, title VARCHAR2, c VARCHAR2)

Which ZX Spectrum has a C=64 of c64, and a Title of ankh?
SELECT zx_spectrum FROM table_name_7 WHERE c = 64 = c64 AND title = "ankh"
SELECT "zx_spectrum" FROM "table_name_7" WHERE "ankh" = "title" AND "c64" = "c" = 64