Database: inn_1
Question: List how many times the number of people in the room reached the maximum occupancy of the room. The number of people include adults and kids.
SQL:
SELECT count(*) FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room  =  T2.RoomId WHERE T2.maxOccupancy  =  T1.Adults + T1.Kids;