CREATE TABLE table_name_10 (d_47 VARCHAR2, d_42 VARCHAR2)

Name the D 47 which has D 42 of d 22
SELECT d_47 FROM table_name_10 WHERE d_42 = "d 22"
SELECT "d_47" FROM "table_name_10" WHERE "d 22" = "d_42"