By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version |
|---|
| PostgreSQL 13.13 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit |
SELECT 1
CREATE TABLE
INSERT 0 6
| op | name | amount | total |
|---|---|---|---|
| 1 | a | 120 | 6 |
| 2 | a | 120 | 6 |
| 5 | b | 80 | 12 |
| 6 | b | 80 | 12 |
| 1 | c | 50 | 5 |
| 3 | c | 50 | 5 |
SELECT 6