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 |
|---|---|---|---|---|
| 2 | TAX | RED | 2 | 0 |
| 2 | TAX | GREEN | 2 | 0 |
| number | ACCOUNT | COLOR |
|---|---|---|
| 1 | TAX | BLUE |
| 1 | PAY | PINK |
| 2 | TAX | RED |
| 2 | TAX | GREEN |
| number | ACCOUNT | COLOR | tax_qty | pay_qty |
|---|---|---|---|---|
| 2 | TAX | RED | 2 | 0 |
| 2 | TAX | GREEN | 2 | 0 |