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