Find the number of rooms with price higher than 120 for different decor.
SELECT decor , count(*) FROM Rooms WHERE basePrice  >  120 GROUP BY decor;
number of rooms with price higher than 120 refers to basePrice > 120; for different decor refers to GROUP BY decor;