By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| POL_NO | AGENT | AGENT_RANKING | SPLIT | grp |
|---|---|---|---|---|
| 100 | 001 | 1.1 | 0.1500 | 0 |
| 100 | 002 | 1.2 | 0.5000 | 0 |
| 100 | 003 | 1.3 | 0.3500 | 0 |
| POL_NO | AGENT | AGENT_RANKING | SPLIT | grp |
|---|---|---|---|---|
| 100 | 001 | 1.1 | 0.1500 | 0 |
| 100 | 002 | 1.2 | 0.5000 | 0 |
| 100 | 003 | 1.3 | 0.3500 | 0 |