What are the master index IDs for all except whose detail includes Schmidt, Kertzmann and Lubowitz?
SELECT master_customer_id FROM  Customer_Master_Index where cmi_details ! =   ( 'Schmidt, Kertzmann and Lubowitz' ) 
all except whose detail includes 'Schmidt, Kertzmann and Lubowitz' refers to exclusion condition on cmi_details; master index IDs refers to master_customer_id;