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.
CREATE TABLE CMI_Cross_References (
    cmi_cross_ref_id VARCHAR,
    source_system_code VARCHAR
)

CREATE TABLE Council_Tax (
    cmi_cross_ref_id VARCHAR
)
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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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. ### Input: CREATE TABLE CMI_Cross_References (
    cmi_cross_ref_id VARCHAR,
    source_system_code VARCHAR
)

CREATE TABLE Council_Tax (
    cmi_cross_ref_id VARCHAR
) ### Response: 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