Task: Text to Code
Input (English): Step 1: find the number of rows of each value of cmi_cross_ref_id in CMI_Cross_References table.
Step 2: find cmi_cross_ref_id, source_system_code in CMI_Cross_References table whose corresponding value in step 1 is greater than or equals 1
Output (English): SELECT cmi_cross_ref_id , source_system_code FROM CMI_Cross_References GROUP BY cmi_cross_ref_id HAVING Count ( * ) > = 1