Sort mysql by score

Hello !
I work on a 3 tables mysql database.
it’s about a game:
one table for name of player,
one for password
and the last one for the score of each player.

I try to sort players by ascendant score without any results so far…
please see the patch below which shows where I am…

any help would be appreciated, thanks !!

sql-formulaire.v4p (24.8 kB)