By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 8 Duplicates: 0 Warnings: 0
Records: 4 Duplicates: 0 Warnings: 0
| d | customer_name | case when t.s is null then 'payments do not exists' else t.s end |
|---|---|---|
| 2020-01-01 | Headley Quincey | 700 |
| 2020-02-01 | Headley Quincey | 100 |
| 2020-03-01 | Headley Quincey | payments do not exists |
| 2020-04-01 | Headley Quincey | payments do not exists |
| 2020-05-01 | Headley Quincey | payments do not exists |
| 2020-06-01 | Headley Quincey | payments do not exists |
| 2020-07-01 | Headley Quincey | payments do not exists |
| 2020-08-01 | Headley Quincey | payments do not exists |
| 2020-09-01 | Headley Quincey | 1000 |
| 2020-10-01 | Headley Quincey | payments do not exists |
| 2020-11-01 | Headley Quincey | payments do not exists |
| 2020-12-01 | Headley Quincey | payments do not exists |
| 2020-01-01 | Andie Smith | payments do not exists |
| 2020-02-01 | Andie Smith | payments do not exists |
| 2020-03-01 | Andie Smith | 400 |
| 2020-04-01 | Andie Smith | payments do not exists |
| 2020-05-01 | Andie Smith | payments do not exists |
| 2020-06-01 | Andie Smith | payments do not exists |
| 2020-07-01 | Andie Smith | payments do not exists |
| 2020-08-01 | Andie Smith | payments do not exists |
| 2020-09-01 | Andie Smith | payments do not exists |
| 2020-10-01 | Andie Smith | payments do not exists |
| 2020-11-01 | Andie Smith | payments do not exists |
| 2020-12-01 | Andie Smith | payments do not exists |
| 2020-01-01 | Sarah Johnson | payments do not exists |
| 2020-02-01 | Sarah Johnson | payments do not exists |
| 2020-03-01 | Sarah Johnson | payments do not exists |
| 2020-04-01 | Sarah Johnson | 500 |
| 2020-05-01 | Sarah Johnson | payments do not exists |
| 2020-06-01 | Sarah Johnson | payments do not exists |
| 2020-07-01 | Sarah Johnson | payments do not exists |
| 2020-08-01 | Sarah Johnson | payments do not exists |
| 2020-09-01 | Sarah Johnson | payments do not exists |
| 2020-10-01 | Sarah Johnson | payments do not exists |
| 2020-11-01 | Sarah Johnson | payments do not exists |
| 2020-12-01 | Sarah Johnson | payments do not exists |
| 2020-01-01 | Ernest Forrest | payments do not exists |
| 2020-02-01 | Ernest Forrest | payments do not exists |
| 2020-03-01 | Ernest Forrest | payments do not exists |
| 2020-04-01 | Ernest Forrest | payments do not exists |
| 2020-05-01 | Ernest Forrest | payments do not exists |
| 2020-06-01 | Ernest Forrest | payments do not exists |
| 2020-07-01 | Ernest Forrest | 800 |
| 2020-08-01 | Ernest Forrest | payments do not exists |
| 2020-09-01 | Ernest Forrest | payments do not exists |
| 2020-10-01 | Ernest Forrest | payments do not exists |
| 2020-11-01 | Ernest Forrest | payments do not exists |
| 2020-12-01 | Ernest Forrest | payments do not exists |