Wasn't trying to bite your head off, just pointing out that we've covered those bases already.

I've tried a variety of tricks from joining the table on itself to using virtual tables and unions, but to no avail. Almost every effort skews the numbers in some way that I can't afford to permit, so I guess the consensus for now is that three queries are necessary after all.