Question of the Day

Crazy Code I

I have this data in my Customer table:

CustomerID CustomerName
1          Steve
2          Andy
3          Brian
4          Allen
5          Devin

I run this code:

SELECT
  t.CustomerID
, c.value
FROM
  ( SELECT
      CustomerID
    , STRING_AGG (CustomerName, ',') AS me
    FROM customer
    GROUP BY CustomerID) t
  CROSS APPLY STRING_SPLIT(me, ',') c;

What is returned?

See possible answers