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