CREATE TABLE CMI_Cross_References (cmi_cross_ref_id VARCHAR, source_system_code VARCHAR)
CREATE TABLE Council_Tax (cmi_cross_ref_id VARCHAR)

What is the cmi cross reference id that is related to at least one council tax entry? List the cross reference id and source system code.
SELECT T1.cmi_cross_ref_id, T1.source_system_code FROM CMI_Cross_References AS T1 JOIN Council_Tax AS T2 ON T1.cmi_cross_ref_id = T2.cmi_cross_ref_id GROUP BY T1.cmi_cross_ref_id HAVING COUNT(*) >= 1
SELECT "T1"."cmi_cross_ref_id", "T1"."source_system_code" FROM "CMI_Cross_References" AS "T1" JOIN "Council_Tax" AS "T2" ON "T1"."cmi_cross_ref_id" = "T2"."cmi_cross_ref_id" GROUP BY "T1"."cmi_cross_ref_id" HAVING COUNT(*) >= 1