That’s because you are 1) writing naive SQL and 2) forcing naive SQL on an arbitrary data structure. You may use VIEWs, CTEs, GROUP BY CUBE/ROLLUP for 1) and re

That’s because you are 1) writing naive SQL and 2) forcing naive SQL on an arbitrary data structure. You may use VIEWs, CTEs, GROUP BY CUBE/ROLLUP for 1) and rethink your structures for 2).