CREATE TABLE HOTELS (price_range INT, star_rating_code VARCHAR, pets_allowed_yn VARCHAR)

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