Return all the rooms with king beds.
select * from rooms where bedtype = 'King'
What are the names and decor of these rooms?
select roomname, decor from rooms where bedtype = 'King'
Sort the list by the room base price.
select roomname, decor from rooms where bedtype = 'King' order by baseprice;