By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 8
| date | user | amount |
|---|---|---|
| 01-01 | Jack | 2 |
| 01-02 | Jack | -7 |
| 01-01 | John | 6 |
| 01-04 | John | -5 |
| 01-05 | John | 1 |
SELECT 5
CREATE TABLE
INSERT 0 8
| date | user | amount |
|---|---|---|
| 01-01 | Jack | 2 |
| 01-02 | Jack | -7 |
| 01-01 | John | 6 |
| 01-04 | John | -5 |
| 01-05 | John | 1 |
SELECT 5