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

Find the number of amenities for each of the dorms that can accommodate more than 100 students. Show scatter chart.
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" "T1" JOIN "Has_amenity" "T2" ON "T1"."dormid" = "T2"."dormid" WHERE "T1"."student_capacity" > 100 GROUP BY "T1"."dormid"