HCC chronic burden — patient risk tiering capstone

Build a patient-level HCC chronic-condition burden score with risk-tier bucketing — the canonical pop-health / ACO query. Compose a multi-CTE pipeline with window functions, distinct counts across multiple flag dimensions, age math from messy date-of-birth, and CASE-based segmentation. This is the resume-grade capstone that hiring managers recognize on sight.