By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| CONTRACTID | BM | SALES_PRODUCT_NUMBER | CURRENCY_TC | END_CUSTOMER_NO | BILLINGS_QUANTITY |
|---|---|---|---|---|---|
| 15939 | 201801 | SP000095923 | EUR | 400009 | 0 |
| 15939 | 201802 | SP000095923 | EUR | 400009 | 60 |
| 15939 | 201803 | SP000095923 | EUR | 400009 | 0 |
| 15939 | 201804 | SP000095923 | EUR | 400009 | 60 |
| 15939 | 201805 | SP000095923 | EUR | 400009 | 0 |
| 15939 | 201806 | SP000095923 | EUR | 400009 | 0 |
| 15939 | 201807 | SP000095923 | EUR | 400009 | 0 |
| 15939 | 201808 | SP000095923 | EUR | 400009 | 40 |
| 15939 | 201809 | SP000095923 | EUR | 400009 | 0 |
| 15939 | 201810 | SP000095923 | EUR | 400009 | 0 |
| 15939 | 201811 | SP000095923 | EUR | 400009 | 60 |
| 15939 | 201812 | SP000095923 | EUR | 400009 | 60 |
| 17923 | 201901 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201902 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201903 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201904 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201905 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201906 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201907 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201908 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201909 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201910 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201911 | SP000095923 | USD | 200009 | 0 |
| 17923 | 201912 | SP000095923 | USD | 200009 | 100 |
| 17923 | 202001 | SP000095923 | USD | 200009 | 200 |
| 17923 | 202002 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202003 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202004 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202005 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202006 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202007 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202008 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202009 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202010 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202011 | SP000095923 | USD | 200009 | 0 |
| 17923 | 202012 | SP000095923 | USD | 200009 | 0 |