CREATE TABLE Student (StuID INT, LName VARCHAR, Fname VARCHAR, Age INT, Sex VARCHAR, Major INT, Advisor INT, city_code VARCHAR)
CREATE TABLE Has_amenity (dormid INT, amenid INT)
CREATE TABLE Dorm (dormid INT, dorm_name VARCHAR, student_capacity INT, gender VARCHAR)
CREATE TABLE Dorm_amenity (amenid INT, amenity_name VARCHAR)
CREATE TABLE Lives_in (stuid INT, dormid INT, room_number INT)

For each dorm, how many amenities does it have. Show the correlation.
SELECT COUNT(*), T1.dormid FROM Dorm AS T1 JOIN Has_amenity AS T2 ON T1.dormid = T2.dormid WHERE T1.student_capacity > 100 GROUP BY T1.dormid
SELECT COUNT(*), "T1"."dormid" FROM "Dorm" AS "T1" JOIN "Has_amenity" AS "T2" ON "T1"."dormid" = "T2"."dormid" WHERE "T1"."student_capacity" > 100 GROUP BY "T1"."dormid"