CREATE TABLE table_name_52 (Id VARCHAR2)

What 1953 has 2 for 1947, and dne as 1938?
SELECT 1953 FROM table_name_52 WHERE 1947 = "2" AND 1938 = "dne"
SELECT 1953 FROM "table_name_52" WHERE "2" = 1947 AND "dne" = 1938