By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
number | ACCOUNT | COLOR |
---|---|---|
1 | TAX | BLUE |
1 | PAY | PINK |
2 | TAX | RED |
2 | TAX | GREEN |
number | ACCOUNT | COLOR | tax_qty | pay_qty |
---|---|---|---|---|
1 | TAX | BLUE | 1 | 1 |
1 | PAY | PINK | 1 | 1 |