CREATE TABLE HOTELS (star_rating_code VARCHAR, price_range INT)

Show the average price of hotels for each star rating code.
SELECT star_rating_code, AVG(price_range) FROM HOTELS GROUP BY star_rating_code
SELECT "star_rating_code", AVG("price_range") FROM "HOTELS" GROUP BY "star_rating_code"