By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| XTypeNo | Xtype | Xvalue | Xmin | Xmax |
|---|---|---|---|---|
| 1 | TypeA | 10 | 100 | 200 |
| 2 | TypeA | 20 | 100 | 200 |
| 3 | TypeA | 30 | 100 | 200 |
| 4 | TypeB | 410 | 200 | 300 |
| 5 | TypeB | 420 | 200 | 300 |
| 6 | TypeB | 430 | 200 | 300 |
| 7 | TypeC | 310 | 300 | 400 |
| 8 | TypeC | 320 | 300 | 400 |
| 9 | TypeC | 330 | 300 | 400 |
| 12 | TypeD | 410 | 400 | 500 |
| 13 | TypeD | 490 | 400 | 500 |
| 14 | TypeD | 550 | 400 | 500 |
| 15 | TypeE | 510 | 500 | 600 |
| 16 | TypeE | 590 | 500 | 600 |
| 17 | TypeE | 450 | 500 | 600 |
| Xtype | XGROUP |
|---|---|
| TypeA | X1 |
| TypeB | X3 |
| TypeC | X2 |