I don't think relational databases can handle sorted sets optimally. Most of online tutorials for leaderboards lean towards using redis.

yes that is still the territory of an database. Someone who knows SQL can do some stuff that reduces the strain on the database a lot.