By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
21 rows affected
| id | count_of_list2_values | list2_values |
|---|---|---|
| 1 | 1 | revolves |
| 3 | 1 | shine |
| 5 | 0 | null |
| 6 | 1 | revolves |
| 10 | 2 | shine,revolves |
| 12 | 0 | null |
Warning: Null value is eliminated by an aggregate or other SET operation.