Task: Text to Code
Input (English): Step 1: For each row in Ref_Attraction_Types table, find the corresponding rows in Hotels table.
Step 2: find each value of Attraction_Type_Code in the results of step 1 along with the average price_range of the corresponding rows to each value
Output (English): SELECT T2.price_range , Avg ( T2.price_range ) FROM Ref_Attraction_Types AS T1 JOIN Hotels AS T2 GROUP BY T1.Attraction_Type_Code