Database: inn_1
Question: How many rooms have king beds? Report the number for each decor type.
SQL:
SELECT decor ,  count(*) FROM Rooms WHERE bedType = "King" GROUP BY decor;