By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
AMOUNT | CUSTOMER_NUMBER | GROUPID | MAX_GROUPID |
---|---|---|---|
1000+ | 5555 | 51 | 57 |
1000+ | 5555 | 60 | 66 |
1000+ | 5555 | 69 | 75 |
2000+ | 6666 | 55 | 61 |
AMOUNT | CUSTOMER_NUMBER | COUNT(*) |
---|---|---|
1000+ | 5555 | 3 |
2000+ | 6666 | 1 |