which rooms have a king bed?
select * from rooms where bedtype = 'King'
what are the decor of those rooms?
select distinct decor from rooms where bedtype = 'King'
show me the names and the decor of the rooms that have a king bed
select roomname, decor from rooms where bedtype = 'King'
show me the price of the rooms also
select roomname, decor, baseprice from rooms where bedtype = 'King'
now sort the list by price
select roomname, decor, baseprice from rooms where bedtype = 'King' order by baseprice