Using MAX_BY / MIN_BY in BigQuery

Just stumbled upon a nifty SQL function in BigQuery that was new to me. Did you know about MAX_BY / MIN_BY? They're essentially shortcuts for ANY_VALUE(columnA HAVING MIN/MAX(columnB)). And guess what? I had no idea you could use HAVING within ANY_VA...