By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
18 rows affected
| customer | orderid | event_date | sales_volume |
|---|---|---|---|
| Customer_A | Order_001 | 2020-01-08 | 130 |
| Customer_A | Order_002 | 2020-01-12 | 120 |
| Customer_A | Order_003 | 2020-01-18 | 115 |
| Customer_A | Order_004 | 2020-06-25 | 445 |
| Customer_B | Order_001 | 2020-04-08 | 325 |
| Customer_B | Order_002 | 2020-04-12 | 875 |
| Customer_B | Order_003 | 2020-04-15 | 910 |
| Customer_B | Order_004 | 2020-04-20 | 723 |
| Customer_B | Order_005 | 2020-06-01 | 982 |
| Customer_B | Order_006 | 2020-06-15 | 100 |
| Customer_C | Order_001 | 2020-01-22 | 300 |
| Customer_C | Order_002 | 2020-01-23 | 500 |
| Customer_C | Order_003 | 2020-04-30 | 665 |
| Customer_C | Order_004 | 2020-06-19 | 250 |
| Customer_C | Order_005 | 2020-06-20 | 322 |
| Customer_D | Order_001 | 2020-01-24 | 400 |
| Customer_E | Order_001 | 2020-01-26 | 200 |
| Customer_E | Order_002 | 2020-06-30 | 924 |