SELECT count(DISTINCT dormid) FROM has_amenity
Find the number of dorms that have some amenity.
SELECT count ( DISTINCT dormid ) FROM has_amenity
select count ( distinct dormid ) from has_amenity
Find the number of dorms that have some amenity .