By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
@@version |
---|
10.2.19-MariaDB-10.2.19+maria~jessie-log |
user_id | country_id | province_id | total_score | rank_total | rank_country | rank_province |
---|---|---|---|---|---|---|
1 | 1 | 3 | 30553 | 1 | 1 | 1 |
14 | 1 | 21 | 23660 | 2 | 2 | 1 |
4 | 1 | 4 | 5697 | 3 | 3 | 1 |
13 | 1 | 2 | 2500 | 4 | 4 | 1 |
12 | 1 | 9 | 1980 | 5 | 5 | 1 |