SELECT decor , count(*) FROM Rooms WHERE basePrice  >  120 GROUP BY decor;
How many rooms cost more than 120, for each different decor?
SELECT decor , count ( * ) FROM Rooms WHERE basePrice > 120 GROUP BY decor ;
select decor , count ( * ) from rooms where baseprice > value group by decor
How many rooms cost more than 120 , for each different decor ?