By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
18 rows affected
ACCOUNTNUMBER | ORG_ID | CNT | CNT_DISTINCT | CNT_ORG | ORGS | ORGS_DISTINCT | MIN_CNT_ORG | MAX_CNT_ORG |
---|---|---|---|---|---|---|---|---|
3333333 | 81 | 2 | 2 | 1 | 81,281 | 81,281 | 1 | 1 |
3333333 | 281 | 2 | 2 | 1 | 81,281 | 81,281 | 1 | 1 |
4444444 | 81 | 4 | 3 | 2 | 81,81,281,404 | 81,281,404 | 1 | 2 |
4444444 | 81 | 4 | 3 | 2 | 81,81,281,404 | 81,281,404 | 1 | 2 |
4444444 | 281 | 4 | 3 | 1 | 81,81,281,404 | 81,281,404 | 1 | 2 |
4444444 | 404 | 4 | 3 | 1 | 81,81,281,404 | 81,281,404 | 1 | 2 |