SELECT star_rating_code ,  avg(price_range) FROM HOTELS GROUP BY star_rating_code
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
Show the average price of hotels for each star rating code .