Can I query to check all source status in node is complete?

This query deletes the node which has status complete but there are other status like incomplete or failed within the sources which gets deleted. How can I check whether all the sources in the node has status complete and delete the node? Thank you in advance!

MATCH (n:Sub)-[:HAS]->(s:Source{status:'COMPLETE'}) DETACH DELETE n