Find the names of all modern rooms with a base price below $160 and two beds.
select roomname from rooms where baseprice < 160 and beds = 2 and decor = 'modern'
Which room has highest price value? tell me the name and Room ID
select roomname, roomid from rooms where baseprice = ( select max ( baseprice ) from rooms )
Which room has lowest price value? tell me the price, the name and Room ID
select baseprice, roomname, roomid from rooms where baseprice = ( select min ( baseprice ) from rooms )
Which room has most number of beds?Tell me the Room ID, Name and decor?
select roomid, roomname, decor from rooms where beds = ( select max ( beds ) from rooms )