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