Database: inn_1
Question: How many rooms cost more than 120, for each different decor?
SQL:
SELECT decor , count(*) FROM Rooms WHERE basePrice  >  120 GROUP BY decor;