SELECT * FROM Invoice WHERE invoiceID IN (
 SELECT invoiceID FROM invoiceLineItems GROUP BY invoiceID HAVING COUNT(*) >=3)
AND invoiceID NOT IN (
 SELECT invoiceID FROM invoicePayments)