CREATE TABLE dorm (dormid NUMBER, dorm_name CLOB, student_capacity NUMBER, gender CLOB)
CREATE TABLE has_amenity (dormid NUMBER, amenid NUMBER)
CREATE TABLE lives_in (stuid NUMBER, dormid NUMBER, room_number NUMBER)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)
CREATE TABLE dorm_amenity (amenid NUMBER, amenity_name CLOB)

What are the first names of all students who live in the dorm with the most amenities?
SELECT T1.fname FROM student AS T1 JOIN lives_in AS T2 ON T1.stuid = T2.stuid WHERE T2.dormid IN (SELECT T2.dormid FROM dorm AS T3 JOIN has_amenity AS T4 ON T3.dormid = T4.dormid JOIN dorm_amenity AS T5 ON T4.amenid = T5.amenid GROUP BY T3.dormid ORDER BY COUNT(*) DESC LIMIT 1)
SELECT "T1"."fname" FROM "student" "T1" JOIN "lives_in" "T2" ON "T1"."stuid" = "T2"."stuid" AND "T2"."dormid" IN (SELECT "T2"."dormid" FROM "dorm" "T3" JOIN "has_amenity" "T4" ON "T3"."dormid" = "T4"."dormid" JOIN "dorm_amenity" "T5" ON "T4"."amenid" = "T5"."amenid" GROUP BY "T3"."dormid" ORDER BY COUNT(*) DESC FETCH FIRST 1 ROWS ONLY)