Database: cre_Theme_park
Question: What are the average prices of hotels grouped by their pet policy.
SQL:
SELECT pets_allowed_yn ,  avg(price_range) FROM HOTELS GROUP BY pets_allowed_yn