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 the average price_range in the results of step 1 whose star_rating_description equals 5
Output (English): SELECT Avg ( T2.price_range ) FROM Ref_Hotel_Star_Ratings AS T1 JOIN Hotels AS T2 ON T1.star_rating_code = T2.star_rating_code WHERE T1.star_rating_description = 5