What is the average price range of hotels for each each star rating code?
select star_rating_code, avg(price_range) from hotels group by star_rating_code