By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| StudentNo | VolunteerOrder | SchoolNo | DepartmentNo | SchoolOrder |
|---|---|---|---|---|
| 001 | 1 | H01 | D01 | 1 |
| 001 | 2 | H01 | D02 | 1 |
| 001 | 3 | H02 | D02 | 2 |
| 001 | 4 | H02 | D03 | 2 |
| 001 | 5 | H02 | D04 | 2 |
| 001 | 6 | H01 | D05 | 3 |
| 001 | 7 | H01 | D06 | 3 |
| 001 | 8 | H01 | D07 | 3 |
| 002 | 1 | H01 | D08 | 1 |
| 002 | 2 | H02 | D09 | 2 |
| 003 | 1 | H01 | D01 | 1 |
| 003 | 2 | H02 | D01 | 2 |
| 003 | 3 | H02 | D02 | 2 |