Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

Problem description & analysis: Each column of database table tempdata can be viewed as an array, with duplicate members: Task: Now we need to group and count each column separately, in JSON format: Code comparisons: SQL: With Grouped AS ( SELE...