Understanding SQL Grouping with a Created Column

Splitting Strings into Multiple Columns with Specific Delimiters in SQL Server Using JSON-Based Approach for Latest Versions