By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
22 rows affected
| StudentID | Date | Attendance | Rnk |
|---|---|---|---|
| 3534543 | 2020-01-01 | N | 0 |
| 3534543 | 2020-01-02 | N | 0 |
| 3534543 | 2020-01-03 | N | 0 |
| 3534543 | 2020-01-04 | Y | 1 |
| 3534543 | 2020-01-05 | Y | 2 |
| 3534543 | 2020-01-06 | Y | 3 |
| 3534543 | 2020-01-07 | Y | 4 |
| 3534543 | 2020-01-08 | Y | 5 |
| 3534543 | 2020-01-09 | N | 0 |
| 23234235 | 2020-01-01 | N | 0 |
| 23234235 | 2020-01-02 | N | 0 |
| 23234235 | 2020-01-03 | N | 0 |
| 23234235 | 2020-01-04 | N | 0 |
| 23234235 | 2020-01-05 | Y | 1 |
| 23234235 | 2020-01-06 | Y | 2 |
| 23234235 | 2020-01-07 | Y | 3 |
| 23234235 | 2020-01-08 | Y | 4 |
| 23234235 | 2020-01-09 | Y | 5 |
| 23234235 | 2020-01-10 | Y | 6 |
| 23234235 | 2020-01-11 | Y | 7 |
| 23234235 | 2020-01-12 | N | 0 |
| 23234235 | 2020-01-13 | N | 0 |