Updated the sample to not require a [manually created] derived aggregation table of salespeople and gender — implemented the aggregation within the Leads table, so that when new salespeople are added, there’s no inconsistency risk. It’s not great data design, but a trick with its benefits and tradeoffs:
