SELECT decor ,  count(*) FROM Rooms WHERE bedType = "King" GROUP BY decor;
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 bedtype = value group by decor
Find the number of rooms with king bed for each decor type .