Database: cre_Theme_park
Question: Find the id and star rating of each hotel and sort them in increasing order of price.
SQL:
SELECT hotel_id ,  star_rating_code FROM HOTELS ORDER BY price_range ASC