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 <table_name> : Hotels col : hotel_id | star_rating_code | pets_allowed_yn | price_range | other_hotel_details row 1 : 123 | 5 | 1 | 2914989.571 |  row 2 : 144 | 4 |  |  |  row 3 : 172 | 5 |  | 17012.682586009 |  row 4 : 222 | 5 | 1 |  |  row 5 : 239 | 3 | 1 |  |  row 6 : 264 | 1 | 1 | 48525.4530675 |  row 7 : 314 | 5 | 1 | 766712918.96763 |  row 8 : 331 | 1 | 1 |  |  row 9 : 350 | 1 |  |  |  row 10 : 373 | 5 | 1 | 250548014.90329 |  row 11 : 376 | 2 |  |  |  row 12 : 379 | 4 | 1 | 38014975.47848 |  row 13 : 420 | 5 | 1 | 9393.86291219 |  row 14 : 421 | 3 |  | 5526556.6412 |  row 15 : 426 | 5 |  | 245.067720121 |  row 16 : 431 | 2 | 1 | 43.729525 |  row 17 : 442 | 2 | 1 | 289775.7331715 |  row 18 : 473 | 1 | 1 | 2374.7971074 |  row 19 : 514 | 5 |  | 1381255.81865 |  row 20 : 555 | 5 | 1 | 5390.432113 |
col : star_rating_code | avg(price_range) row 1 : 1 | 12725.062543725 row 2 : 2 | 96606.4875655 row 3 : 3 | 2763278.3206 row 4 : 4 | 19007487.73924 row 5 : 5 | 113509913.4784335