Sort all the rooms by the maximum occupancy.
select * from rooms order by maxoccupancy desc
Which room has the largest capacity?
select * from rooms order by maxoccupancy desc limit 1;
Tell me the name of that room.
select roomname from rooms order by maxoccupancy desc limit 1;