Task: Text to Code
Input (English): Step 1: For each row in Ref_Hotel_Star_Ratings table, find the corresponding rows in Hotels table.
Step 2: find hotel_id, star_rating_description, price_range of the results of step 1 ordered ascending by price_range
Output (English): SELECT T2.hotel_id , T1.star_rating_description , T2.price_range FROM Ref_Hotel_Star_Ratings AS T1 JOIN Hotels AS T2 ON T1.star_rating_code = T2.star_rating_code ORDER BY T2.price_range Asc