What is the average room price in this inn?
select avg(baseprice) from rooms
Find all the rooms that cost more than that.
select * from rooms where baseprice > ( select avg(baseprice) from rooms );
What are their room names?
select roomname from rooms where baseprice > ( select avg(baseprice) from rooms );