What are the resident details containing the substring 'Miss'?
CREATE TABLE Residents (other_details VARCHAR)
SELECT other_details FROM Residents WHERE other_details LIKE '%Miss%'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Residents (other_details VARCHAR) Question: What are the resident details containing the substring 'Miss'? [/INST] SELECT other_details FROM Residents WHERE other_details LIKE '%Miss%' </s>