How can I get a valid rank counter?

How can I get a valid rank counter?
I hope you found a solution that worked for you 🙂
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA |
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/203092/elikill58)Elikill58 |
(dba.stackexchange.com/users/237716/ergest-basha)Ergest Basha |
A special thanks goes out to the (https://dba.stackexchange.com/questions/325994/how-can-i-get-a-valid-rank-counter)Stackexchange community |

I wish you all a wonderful day! Stay safe 🙂

order-by mariadb mariadb-10.5