SELECT count(DISTINCT dormid) FROM has_amenity
How many dorms have amenities?
SELECT count ( DISTINCT dormid ) FROM has_amenity
select count ( distinct dormid ) from has_amenity
How many dorms have amenities ?