Cohort intersection across two time windows via two CTEs joined on the cohort key. The 'switcher' analysis — HCPs who prescribed a competitor before the launch and then started the new brand after — is the canonical brand-momentum diagnostic for any pharma launch. Forecasting analysts use the switcher count as the leading indicator of Year-2 trajectory.