CREATE TABLE table_name_76 (first VARCHAR, surname VARCHAR)

Which first's surname is Cook?
SELECT first FROM table_name_76 WHERE surname = "cook"
SELECT "first" FROM "table_name_76" WHERE "cook" = "surname"