What is the D42 associated with a D47 of d 27?
CREATE TABLE table_name_31 (d_42 VARCHAR, d_47 VARCHAR)
SELECT d_42 FROM table_name_31 WHERE d_47 = "d 27"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_31 (d_42 VARCHAR, d_47 VARCHAR) Question: What is the D42 associated with a D47 of d 27? [/INST] SELECT d_42 FROM table_name_31 WHERE d_47 = "d 27" </s>