Find the number of rooms with king bed for each decor type.
create table rooms (decor varchar, bedtype varchar, PRIMARY KEY (decor))
select decor, count(*) from rooms where bedtype = "king" group by decor