By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version |
|---|
| PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-4), 64-bit |
3 rows affected
3 rows affected
1 rows affected
| task | status | last_update |
|---|---|---|
| A | 1 | 2022-04-28 |
| A | 3 | 2022-05-01 |
| A | 5 | 2022-05-05 |
| B | 1 | 2022-04-28 |
| B | 3 | 2022-05-01 |
| B | 5 | 2022-05-05 |
| B | 5 | 2022-05-15 |
| date1 | task | first_value |
|---|---|---|
| 2022-04-28 | B | 1 |
| 2022-04-28 | B | 1 |
| 2022-04-29 | B | 1 |
| 2022-04-30 | B | 1 |
| 2022-05-01 | B | 3 |
| 2022-05-01 | B | 3 |
| 2022-05-02 | B | 3 |
| 2022-05-03 | B | 3 |
| 2022-05-04 | B | 3 |
| 2022-05-05 | B | 5 |
| 2022-05-05 | B | 5 |
| 2022-05-06 | B | 5 |
| 2022-05-07 | B | 5 |
| 2022-05-08 | B | 5 |
| 2022-05-09 | B | 5 |
| 2022-05-10 | B | 5 |
| _date1 | _first_ctask | _first_cstatus |
|---|---|---|
| 2022-04-28 | A | 1 |
| 2022-04-28 | A | 1 |
| 2022-04-29 | A | 1 |
| 2022-04-30 | A | 1 |
| 2022-05-01 | A | 3 |
| 2022-05-01 | A | 3 |
| 2022-05-02 | A | 3 |
| 2022-05-03 | A | 3 |
| 2022-05-04 | A | 3 |
| 2022-05-05 | A | 5 |
| 2022-05-05 | A | 5 |
| 2022-04-28 | B | 1 |
| 2022-04-28 | B | 1 |
| 2022-04-29 | B | 1 |
| 2022-04-30 | B | 1 |
| 2022-05-01 | B | 3 |
| 2022-05-01 | B | 3 |
| 2022-05-02 | B | 3 |
| 2022-05-03 | B | 3 |
| 2022-05-04 | B | 3 |
| 2022-05-05 | B | 5 |
| 2022-05-05 | B | 5 |
| 2022-05-06 | B | 5 |
| 2022-05-07 | B | 5 |
| 2022-05-08 | B | 5 |
| 2022-05-09 | B | 5 |
| 2022-05-10 | B | 5 |
| 2022-05-11 | B | 5 |
| 2022-05-12 | B | 5 |
| 2022-05-13 | B | 5 |
| 2022-05-14 | B | 5 |
| 2022-05-15 | B | 5 |