Schema: CREATE TABLE has_amenity (dormid VARCHAR)
Question: Find the number of dorms that have some amenity.
SQL: SELECT COUNT(DISTINCT dormid) FROM has_amenity