CREATE TABLE table_name_35 (d_47 VARCHAR2, d_48 VARCHAR2, d_42 VARCHAR2)

Name the D 47 when it has a D 48 of d 49 and D 42 of r 42
SELECT d_47 FROM table_name_35 WHERE d_48 = "d 49" AND d_42 = "r 42"
SELECT "d_47" FROM "table_name_35" WHERE "d 49" = "d_48" AND "d_42" = "r 42"