How many rooms cost more than 120, for each different decor?
SELECT decor , count(*) FROM Rooms WHERE basePrice  >  120 GROUP BY decor;
rooms cost more than 120 refers to basePrice > 120; count for each different decor refers to COUNT(*) GROUP BY decor;