SELECT decor , count(*) FROM Rooms WHERE basePrice  >  120 GROUP BY decor;
Find the number of rooms with price higher than 120 for different decor.
SELECT decor , count ( * ) FROM Rooms WHERE basePrice > 120 GROUP BY decor ;
select decor , count ( * ) from rooms where baseprice > value group by decor
Find the number of rooms with price higher than 120 for different decor .