By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | number_with_name |
|---|---|
| 1 | 200-2 David |
| 2 | 200-2-2 Peter |
| 3 | 200-2-2-9 James |
| 4 | 200 Robert |
| 5 | 200-2-3 Siva |
| 6 | 200-2-5 Denny |
| 8 | 200-2-9 Rose |
| 9 | 200-3 Kiki |
| 10 | 100-3-2 Viva |
| 11 | 100-3-15 Proton |
| 12 | 100-3-6 Saga |
| 13 | 100 Liver |
| 14 | 100-3 Shawn |
| 15 | 100-3-5-1 Kola |
| 16 | 100-3-5-8 Frankie |
| 17 | 100-3-5 Jala |
| id | number_with_name |
|---|---|
| 13 | 100 Liver |
| 14 | 100-3 Shawn |
| 10 | 100-3-2 Viva |
| 16 | 100-3-5-8 Frankie |
| 15 | 100-3-5-1 Kola |
| 17 | 100-3-5 Jala |
| 12 | 100-3-6 Saga |
| 11 | 100-3-15 Proton |
| 4 | 200 Robert |
| 1 | 200-2 David |
| 2 | 200-2-2 Peter |
| 3 | 200-2-2-9 James |
| 5 | 200-2-3 Siva |
| 6 | 200-2-5 Denny |
| 8 | 200-2-9 Rose |
| 9 | 200-3 Kiki |