CREATE TABLE reservations (code DECIMAL, room TEXT, checkin TEXT, checkout TEXT, rate DECIMAL, lastname TEXT, firstname TEXT, adults DECIMAL, kids DECIMAL)
CREATE TABLE rooms (roomid TEXT, roomname TEXT, beds DECIMAL, bedtype TEXT, maxoccupancy DECIMAL, baseprice DECIMAL, decor TEXT)

What is the name of the room that can accommodate the most people?
SELECT roomname FROM rooms ORDER BY maxoccupancy DESC LIMIT 1
SELECT "roomname" FROM "rooms" ORDER BY "maxoccupancy" DESC NULLS LAST LIMIT 1