Ryoma Nagata on 20 Apr 2024 12:35:34
Non-aggregate columns in select can be used for GROUP BY.
Snowflake example (https://docs.snowflake.com/en/sql-reference/constructs/group-by
>Specifies that all items in the SELECT list that do not use aggregate functions should be used for grouping.