How many customers in the machinery segment are in debt?
machinery segment refers to c_mktsegment = 'MACHINERY'; in debt refers to c_acctbal < 0
SELECT COUNT(c_custkey) FROM customer WHERE c_acctbal < 0 AND c_mktsegment = 'MACHINERY'