Database: real_estate_rentals
Question: What are the different room sizes, and how many of each are there?
SQL:
SELECT room_size ,  count(*) FROM Rooms GROUP BY room_size