Database: inn_1
Question: Find the name of rooms whose price is higher than the average price.
SQL:
SELECT roomName FROM Rooms WHERE basePrice  >  ( SELECT avg(basePrice) FROM Rooms );