Name the D 47 when it has a D 48 of d 49 and D 42 of r 42
CREATE TABLE table_name_35 (d_47 VARCHAR, d_48 VARCHAR, d_42 VARCHAR)
SELECT d_47 FROM table_name_35 WHERE d_48 = "d 49" AND d_42 = "r 42"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_35 (d_47 VARCHAR, d_48 VARCHAR, d_42 VARCHAR) Question: Name the D 47 when it has a D 48 of d 49 and D 42 of r 42 [/INST] SELECT d_47 FROM table_name_35 WHERE d_48 = "d 49" AND d_42 = "r 42" </s>