Schema: CREATE TABLE Rooms (decor VARCHAR, basePrice INTEGER)
Question: Find the number of rooms with price higher than 120 for different decor.
SQL: SELECT decor, COUNT(*) FROM Rooms WHERE basePrice > 120 GROUP BY decor