Database: cre_Theme_park
Question: Show the average price range of hotels that have 5 star ratings and allow pets.
SQL:
SELECT avg(price_range) FROM HOTELS WHERE star_rating_code  =  "5" AND pets_allowed_yn  =  1