By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| SCHOOL_NAME | STUDENT_NAME | CLASS_ID | RNK | CNT | RN |
|---|---|---|---|---|---|
| AMM | Adam | AMM-1-1-1 | 1 | 2 | 1 |
| AMM | joe | AMM-1-1-2 | 2 | 2 | 2 |
| AMM | Albert | AMM-1-2-1 | 1 | 2 | 1 |
| AMM | Nancy | AMM-1-2-2 | 2 | 2 | 2 |
| IRB | Frank | IRB-1-1-1 | 1 | 2 | 1 |
| IRB | Mike | IRB-1-1-2 | 2 | 2 | 2 |