Day 28 of a 30-day SQL challenge focuses on finding the length of comma-separated values stored in a column. Two database solutions are demonstrated: PostgreSQL uses string_to_array() and unnest() to split values into rows, then string_agg() to recombine lengths; an alternative PostgreSQL approach uses CROSS JOIN LATERAL. For Microsoft SQL Server, the solution uses CROSS APPLY with STRING_SPLIT() to achieve the same result. Both approaches handle splitting delimited strings into rows, computing individual lengths, and aggregating results back per ID.
•12m watch time
1 Impression