Database: inn_1
Question: What are the name of rooms that cost more than the average.
SQL:
SELECT roomName FROM Rooms WHERE basePrice  >  ( SELECT avg(basePrice) FROM Rooms );