Multi-CTE pipeline with three derived facts (calls per rep, attributed Rx via territory→HCP, rank within manager). The exercise teaches the load-bearing 'fact_rx → dim_hcp.territory_id ↔ dim_rep.territory_id' attribution chain, which is the most common 'where does the territory_id live?' confusion for new pharma analysts.