How to find user rankings and world rankings?
please SQL query how to do
SELECT leadersboards.leaderboard_id, users.name, users.country, users.points, users.email, classboards.score, FIND_IN_SET (users.points, (SELECT GROUP_CONCAT (users.points ORDER BY users.points DESC) FROM users) FROM) ) AS world_rank, FIND_IN_SET (rankings.score, (SELECT GROUP_CONCAT (ORDER BY rankings.score ORDER BY rankings.score DESC) FROM rankings)), rank AS, rankings.created_date, rankings.time_stamp users who include rankings in user rankings .user_id = leaderboards. users.user_type = 2
Above the query, I have the world rankings, but how to find the ranking by country