With the new MIN_BY and MAX_BY functions, you can quickly return the value(s) in one column conditionally based on another column's maximum or minimum value. Answering this question has always been possible with often complicated subqueries, but
with this recent Snowflake release, we get a clean function that performs the same task with much less code.