User Story
As a sales representative, I want to identify all accounts that have contacts and no closed opportunities or cases, so that I can focus on potential revenue-generating opportunities.
SOQL
SELECT Id, Name
FROM Account
WHERE Id IN (SELECT AccountId FROM Contact)
AND Id NOT IN (SELECT AccountId FROM Opportunity WHERE IsClosed = TRUE)
AND Id NOT IN (SELECT AccountId FROM Case WHERE IsClosed = TRUE)