For each modern room, find the maximum number of people who can stay in.
select maxoccupancy from rooms where decor = 'modern';
What is the total number of people who can stay in the modern rooms of this inn?
select sum(maxoccupancy) from rooms where decor = 'modern';