Database: cre_Theme_park
Question: Show the id and star rating of each hotel, ordered by its price from low to high.
SQL:
SELECT hotel_id ,  star_rating_code FROM HOTELS ORDER BY price_range ASC