A nice feature of snowflake is the min_by/max_by functions.

https://docs.snowflake.com/en/sql-reference/functions/min_by