By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| hobbies_1 | hobbies_2 | count |
|---|---|---|
| A | null | 3 |
| B | null | 1 |
| null | E | 1 |
| null | F | 2 |
| null | A | 1 |
SELECT 5
| hobbies_1 | hobbies_2 |
|---|---|
| {"A": 3, "B": 1} | {"A": 1, "E": 1, "F": 2} |
SELECT 1
| hobbies_1 | hobbies_2 | count |
|---|---|---|
| A | null | 3 |
| B | null | 1 |
| null | E | 1 |
| null | F | 2 |
| null | A | 1 |
SELECT 5
| hobbies_1 | hobbies_2 |
|---|---|
| {"A": 3, "B": 1} | {"A": 1, "E": 1, "F": 2} |
SELECT 1