Which distinct source system code includes the substring 'en'?
SELECT DISTINCT source_system_code FROM cmi_cross_references WHERE source_system_code LIKE '%en%'
includes the substring 'en' refers to LIKE '%en%'; distinct source system code refers to DISTINCT(source_system_code);