I'm trying to summarize amounts and count opportunities in this quarter that are related to accounts with no prior opportunities closed won.
In normal SQL this would be a very easy join on the same opportunity table.
One way would be to build a list with all accounts with prior closed opportunities and use that list to filter the new opportunities. Is there another way to do this without returning that many rows to just aggregate at the end?
Just want to make sure I'm not missing something very basic.