Payer denial rates above 30%

GROUP BY + HAVING with conditional aggregation across a join.