Combining ANY_VALUE with HAVING in BigQuery

Here's another rather rare instance where I've used ANY_VALUE inBigQuery. It's basically an aggregation function like SUM or COUNT except it retrieves a arbitrary value from the grouping. I've posted about ANY_VALUE before, but today's query was a bi...