ค้นหาชื่อนักศึกษาที่อาศัยอยู่ในหอพักที่มีสิ่งอำนวยความสะดวกมากที่สุด ไม่จำเป็นต้องใช้โต๊ะทั้งหมด
Find the first name of students who are living in the dorm that has most number of amenities.It is not neccessary to use all the tables.
 dorm_amenity:  (amenid [ VARCHAR) ]
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)