Task: Text to Code
Input (English): Step 1: For each row in Asset_Parts table, find corresponding rows in Parts table and in Assets table.
Step 2: find other_asset_details of the results of step 1 ordered ascending by chargeable_amount
Output (English): SELECT T2.other_asset_details FROM Parts AS T1 JOIN Assets AS T2 JOIN Asset_Parts AS T3 ON T1.part_id = T3.part_id AND T3.asset_id = T2.asset_id ORDER BY T1.chargeable_amount Asc