What are the renting arrears tax ids related to the customer master index whose detail is not 'Schmidt, Kertzmann and Lubowitz'?
create table rent_arrears (council_tax_id varchar, cmi_cross_ref_id varchar, PRIMARY KEY (council_tax_id)); create table customer_master_index (master_customer_id varchar, cmi_details varchar, PRIMARY KEY (master_customer_id)); create table cmi_cross_references (cmi_cross_ref_id varchar, master_customer_id varchar, PRIMARY KEY (cmi_cross_ref_id))
select t1.council_tax_id from rent_arrears as t1 join cmi_cross_references as t2 on t1.cmi_cross_ref_id = t2.cmi_cross_ref_id join customer_master_index as t3 on t3.master_customer_id = t2.master_customer_id where t3.cmi_details <> 'schmidt ,  kertzmann and lubowitz'