CREATE TABLE Rooms (decor VARCHAR, bedType VARCHAR)

Find the number of rooms with king bed for each decor type.
SELECT decor, COUNT(*) FROM Rooms WHERE bedType = "King" GROUP BY decor
SELECT "decor", COUNT(*) FROM "Rooms" WHERE "King" = "bedType" GROUP BY "decor"