SELECT star_rating_code ,  avg(price_range) FROM HOTELS GROUP BY star_rating_code
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
select star_rating_code , avg ( price_range ) from hotels group by star_rating_code
What is the average price range of hotels for each each star rating code ?