Task: Text to Code
Input (English): SQL: SELECT source_system_code , cmi_cross_ref_id FROM CMI_Cross_References ORDER BY source_system_code Asc
Feedback: Need to find benifit id instead of cmi cross reference id , and also order by benifit id for corresponding cmi cross reference id .
Output (English): SELECT T1.source_system_code ,  T2.council_tax_id FROM CMI_Cross_References AS T1 JOIN Benefits_Overpayments AS T2 ON T1.cmi_cross_ref_id  =  T2.cmi_cross_ref_id ORDER BY T2.council_tax_id