What are the bed type of room id RND?
select bedtype from rooms where roomid = "RND"
What type of decor in room name Abscond or bolster?
select decor from rooms where roomname = "Abscond or bolster"
Find the average and minimum price of the rooms in different decor.
select decor, avg ( baseprice ), min ( baseprice ) from rooms group by decor