Retaining Additional Columns when Using MIN or MAX with GROUP BY in SQL

Finding the Smallest Non-Null Value for Each Row in a Multi-Column Table Using Snowflake's Array Functions