HAVING vs WHERE: filter on the aggregate, not the row source. Pharma forecasting analysts comb the HCP universe for high-NRx-share prescribers — those who prescribe a lot of NEW Rx (rather than refilling existing patients) — because they're the leading indicator of brand momentum. Conditional aggregation + HAVING + multi-condition filter.