By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| exdate | vendor | product |
|---|---|---|
| 2021-08-01 | 01 | 蘋果 |
| 2021-08-02 | 01 | 芭樂 |
| 2021-08-03 | 01 | 水蜜桃 |
| 2021-09-01 | 01 | 蘋果 |
| 2021-09-02 | 01 | 西瓜 |
| 2021-09-03 | 01 | 香蕉 |
| 2021-08-05 | 01 | 番茄 |
| 2021-08-01 | 02 | 蘋果 |
| 2021-08-02 | 02 | 芭樂 |
| 2021-08-03 | 02 | 水蜜桃 |
| YearMonth | vendor | product | product2 |
|---|---|---|---|
| 202108 | 01 | 蘋果 | 芭樂 |
| 202109 | 01 | 蘋果 | 西瓜 |
| 202108 | 02 | 蘋果 | 芭樂 |