What are the cmi cross reference ids that are related to the benefits and overpayments.
select cmi_cross_ref_id from benefits_overpayments
Show me their source system codes along with the benefit id.
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 them by the benefit id.
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