WHAT IS ROOM ID OF MODERN DECOR?
select roomid from rooms where decor = 'modern'
OK .HOW MANY ROOMS IN KING BED TYPE?
select count ( * ) from rooms where bedtype = 'King'
WHAT IS ROOM NAME  of rooms that have a king bed.?
select roomname from rooms where bedtype = 'King'