By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ORIGIN_ID | ORIGIN_NAME | TEMP_ORIGIN_ID |
|---|---|---|
| 1111-1 | AAA | 11110001 |
| 1111-2 | AAA | 11110001 |
| 1111-3 | BBB | 11110002 |
| 1111-4 | BBB | 11110002 |
| 1111-5 | BBB | 11110002 |
| 1111-6 | CCC | 11110003 |
| 1111-7 | CCC | 11110003 |
| 1111-8 | DDD | 11110004 |