Show me the list of cmi cross reference ids please!
select cmi_cross_ref_id from cmi_cross_references
Which of those cmi cross reference ids are related to parking taxes?
select t1.cmi_cross_ref_id from cmi_cross_references as t1 join parking_fines as t2 on t1.cmi_cross_ref_id = t2.cmi_cross_ref_id
What about cmi cross reference ids that not related?
select cmi_cross_ref_id from cmi_cross_references where cmi_cross_ref_id not in ( select t1.cmi_cross_ref_id from cmi_cross_references as t1 join parking_fines as t2 on t1.cmi_cross_ref_id = t2.cmi_cross_ref_id )