Filtering SQL Result by Condition to Receive Only One Row per Customer for Each Product Type.

Exploding JSON Arrays in SQL Server 2019: A Step-by-Step Guide