A string expression, usually a column name. For each row in the group, the value of string-expression is added to the result string, with values separated by delimiter-string. When DISTINCT is specified, only unique string-expression values are added.
A delimiter string for the list items. The default setting is a comma. There is no delimiter if a value of NULL or an
empty string is supplied. The delimiter-string must be a constant.
The LIST function returns the concatenation (with delimiters) of all the non-NULL values of X for each row in the group. If
there does not exist at least one row in the group with a definite X-value, then LIST( X ) returns the empty string.
NULL values and empty strings are ignored by the LIST function.
A LIST function cannot be used as a window function, but it can be used as input to a window function.