query: 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
question: 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.
query_toks: 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
query_toks_no_value: 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 ( * ) > = value
question_toks: 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.