By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | adminno | fullname | term | year | marks | student_rank |
|---|---|---|---|---|---|---|
| 4 | p004 | Joan | Term I | 2021 | 700 | 1 |
| 2 | p002 | Jane | Term I | 2021 | 400 | 2 |
| 1 | p001 | john | Term I | 2021 | 300 | 3 |
| 3 | p003 | Jack | Term I | 2021 | 200 | 4 |