By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| StudentID | Subject |
|---|---|
| 1 | History |
| 2 | Geography |
| 2 | History |
| 3 | Geography |
| 3 | History |
| 3 | Maths |
| StudentID | Subject |
|---|---|
| 1 | History |
| 2 | Geography |
| 2 | History |
| 3 | Geography |
| 3 | History |
| 3 | Maths |