Schema: CREATE TABLE Rooms (maxOccupancy INTEGER, decor VARCHAR)
Question: What is the total number of people who could stay in the modern rooms in this inn?
SQL: SELECT SUM(maxOccupancy) FROM Rooms WHERE decor = 'modern'