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)
Find the first name of students who are living in the dorm that has most number of 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 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 value )
Find the first name of students who are living in the dorm that has most number of amenities .