We have a synchronized data extension from Sales Cloud coming into our SFMC instance. In the Opportunities table, it is possible for a single customer to have multiple Opportunities in various stages, depending on which dealership received the lead. We have Opportunity stages such as New, In-Process, Dormant, Deposit Received, etc.
What I'm trying to do is write a query that will only bring in emails from Opportunities in a "Dormant" stage but that also does not have an opportunity based on the same email in either "In-Process" or "Deposit Received"
Any guidance on how to approach this would be greatly appreciated. Thanks !