glafarge/request.sql

## request.sql
SELECT id, username, score,
	FIND_IN_SET(
		score, (SELECT  GROUP_CONCAT(DISTINCT score ORDER BY score DESC) FROM score)
	) as rank
FROM scores;

## result.md

      
    Raw
  

              result.md
            
          
id
username
score
rank


1
wallace
95
2


2
gromit
97
1


3
shaun
85
4


4
mcgraw
92
3


5
preston
92
3
	SELECT id, username, score,
	FIND_IN_SET(
	score, (SELECT GROUP_CONCAT(DISTINCT score ORDER BY score DESC) FROM score)
	) as rank
	FROM scores;