Find the number of dorms that have some amenity.
CREATE TABLE has_amenity (dormid VARCHAR)
SELECT COUNT(DISTINCT dormid) FROM has_amenity
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE has_amenity (dormid VARCHAR) Question: Find the number of dorms that have some amenity. [/INST] SELECT COUNT(DISTINCT dormid) FROM has_amenity </s>