SELECT roomname FROM rooms WHERE baseprice BETWEEN 120 AND 150
Which rooms cost between 120 and 150? Give me the room names.
SELECT roomname FROM rooms WHERE baseprice BETWEEN 120 AND 150
select roomname from rooms where baseprice between value and value
Which rooms cost between 120 and 150 ? Give me the room names .