Path capstone. Multi-CTE pipeline that combines aggregation, parallel window functions (NTILE deciles + RANK within specialty), and CASE-based segment labeling. The output is the HCP segmentation file that brand teams use to size the call list, prioritize digital outreach, and forecast per-HCP revenue. Every Hard / Expert pattern in this path appears in this one query.