I need a count of Contacts that are associated with Accounts that have ever had an Opportunity. Here's the query as I think it should be
SELECT count() FROM Contact WHERE AccountID in (SELECT id FROM Account WHERE AccountID in (SELECT AccountId FROM Opportunity) )
I get a malformed query error: Nesting of semi join sub-selects is not supported
My googling tells me I need to break this up into two queries, but I need to do this in Workbench for "reasons". Am I out of luck?