What state is Ding and has a royal house of Ji?
CREATE TABLE table_name_87 (state VARCHAR, royal_house VARCHAR, name VARCHAR)
SELECT state FROM table_name_87 WHERE royal_house = "ji" AND name = "ding"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_87 (state VARCHAR, royal_house VARCHAR, name VARCHAR) Question: What state is Ding and has a royal house of Ji? [/INST] SELECT state FROM table_name_87 WHERE royal_house = "ji" AND name = "ding" </s>