Using WHERE inside aggregate functions

I've previously shared how aggregate functions in BigQuery SQL can pick their rows with HAVING MAX / HAVING MIN. WHERE is now supported in preview (yes, I'm the tenth person posting it). It filters