Which rooms cost between 120 and 150? Give me the room names.
SELECT roomname FROM rooms WHERE baseprice BETWEEN 120 AND 150
rooms cost between 120 and 150 refers to baseprice BETWEEN 120 AND 150; room names refers to SELECT roomname;