Which rooms have king beds?
select * from rooms where bedtype = "King"
Group all the rooms with king beds according to the decor type.
select * from rooms where bedtype = "King" group by decor;
Count the number of rooms for each decor type.
select decor, count(*) from rooms where bedtype = "King" group by decor;