Postgres JSON Aggregation for Multi-Level Table Analysis

Using Window Functions to Count with HAVING Sum Restrictions in a JOIN without Sub-Queries