Find the capacity and gender type of the dorm whose name has substring ‘Donor’.
CREATE TABLE dorm (student_capacity VARCHAR, gender VARCHAR, dorm_name VARCHAR)
SELECT student_capacity, gender FROM dorm WHERE dorm_name LIKE '%Donor%'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE dorm (student_capacity VARCHAR, gender VARCHAR, dorm_name VARCHAR) Question: Find the capacity and gender type of the dorm whose name has substring ‘Donor’. [/INST] SELECT student_capacity, gender FROM dorm WHERE dorm_name LIKE '%Donor%' </s>