Three-way JOIN with category-filtered aggregation and a provider-level rollup. Practice the targeted-leakage pattern: pick a single denial reason that maps to a fixable behavior (CO-97 bundling = coding/edit-rule misses), aggregate it by the actor whose behavior it tracks (provider), and surface the providers most likely to benefit from a corrective intervention.