Table: game_catalog
Columns: title
genre
c_64
zx_spectrum
others
year
format

Question: Which ZX Spectrum has a Year larger than 1984, and a Genre of arcade/strategy?
SQL: SELECT "zx_spectrum" FROM game_catalog WHERE "year" > 1984 AND "genre" = 'arcade/strategy'

Question: How many years have a Title of kriegspiel?
SQL: SELECT COUNT("year") FROM game_catalog WHERE "title" = 'kriegspiel'

Question: Which ZX Spectrum has a C=64 of c64, and a Title of ankh?
SQL: SELECT "zx_spectrum" FROM game_catalog WHERE "c_64" = 'c64' AND "title" = 'ankh'

Question: Which Title has Others of amstrad cpc, and a Genre of arcade?
SQL: SELECT "title" FROM game_catalog WHERE "others" = 'amstrad cpc' AND "genre" = 'arcade'