Show the id and star rating of each hotel, ordered by its price from low to high.
CREATE TABLE HOTELS (hotel_id VARCHAR, star_rating_code VARCHAR, price_range VARCHAR)
SELECT hotel_id, star_rating_code FROM HOTELS ORDER BY price_range
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE HOTELS (hotel_id VARCHAR, star_rating_code VARCHAR, price_range VARCHAR) Question: Show the id and star rating of each hotel, ordered by its price from low to high. [/INST] SELECT hotel_id, star_rating_code FROM HOTELS ORDER BY price_range </s>