SELECT count(*) FROM Customers WHERE customer_id NOT IN ( SELECT customer_id FROM Customer_Payments );
How many customers have no payment histories?
SELECT count ( * ) FROM Customers WHERE customer_id NOT IN ( SELECT customer_id FROM Customer_Payments ) ;
select count ( * ) from customers where customer_id not in ( select customer_id from customer_payments )
How many customers have no payment histories ?