CREATE TABLE HOTELS (pets_allowed_yn VARCHAR, price_range INT)

Show the average price of hotels for different pet policy.
SELECT pets_allowed_yn, AVG(price_range) FROM HOTELS GROUP BY pets_allowed_yn
SELECT "pets_allowed_yn", AVG("price_range") FROM "HOTELS" GROUP BY "pets_allowed_yn"