MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE StudentScores
    (`gender` varchar(1), `student` varchar(8), `score` int)
;
    
INSERT INTO StudentScores
    (`gender`, `student`, `score`)
VALUES
    ('M', 'Tobi', 92),
    ('M', 'Tom', 92),    
    ('M', 'Sam', 89),
    ('M', 'Ron', 100),
    ('F', 'Mary', 97),
    ('F', 'Emily', 95),
    ('F', 'Jennifer', 89),
    ('F', 'Lori', 89),
    ('F', 'Audra', 84);

Records: 9  Duplicates: 0  Warnings: 0


-- ROW_NUMBER breaks the tie
SELECT *
	,ROW_NUMBER() OVER (
		ORDER BY score DESC
		) AS RowNum
FROM StudentScores


gender
student
score
RowNum


M
Ron
100
1

F
Mary
97
2

F
Emily
95
3

M
Tobi
92
4

M
Tom
92
5

M
Sam
89
6

F
Jennifer
89
7

F
Lori
89
8

F
Audra
84
9


-- RANK() keeps the tie and skip numbers
SELECT *
	,RANK() OVER (
		ORDER BY score DESC
		) AS RankNum
FROM StudentScores


gender
student
score
RankNum


M
Ron
100
1

F
Mary
97
2

F
Emily
95
3

M
Tobi
92
4

M
Tom
92
4

M
Sam
89
6

F
Jennifer
89
6

F
Lori
89
6

F
Audra
84
9


-- DENSE_RANK() keeps the tie as well, but does NOT skip numbers
SELECT *
	,DENSE_RANK() OVER (
		ORDER BY score DESC
		) AS DenseRankNum
FROM StudentScores


gender
student
score
DenseRankNum


M
Ron
100
1

F
Mary
97
2

F
Emily
95
3

M
Tobi
92
4

M
Tom
92
4

M
Sam
89
5

F
Jennifer
89
5

F
Lori
89
5

F
Audra
84
6


SELECT *
	,ROW_NUMBER() OVER (
		ORDER BY score DESC
		) AS RowNum
	,RANK() OVER (
		ORDER BY score DESC
		) AS RankNum
	,DENSE_RANK() OVER (
		ORDER BY score DESC
		) AS DenseRankNum
FROM StudentScores


gender
student
score
RowNum
RankNum
DenseRankNum


M
Ron
100
1
1
1

F
Mary
97
2
2
2

F
Emily
95
3
3
3

M
Tobi
92
4
4
4

M
Tom
92
5
4
4

M
Sam
89
6
6
5

F
Jennifer
89
7
6
5

F
Lori
89
8
6
5

F
Audra
84
9
9
6


SELECT *
	,ROW_NUMBER() OVER (
		PARTITION BY gender ORDER BY score DESC
		) AS RowNum
	,RANK() OVER (
		PARTITION BY gender ORDER BY score DESC
		) AS RankNum
	,DENSE_RANK() OVER (
		PARTITION BY gender ORDER BY score DESC
		) AS DenseRankNum
FROM StudentScores


gender
student
score
RowNum
RankNum
DenseRankNum


F
Mary
97
1
1
1

F
Emily
95
2
2
2

F
Jennifer
89
3
3
3

F
Lori
89
4
3
3

F
Audra
84
5
5
4

M
Ron
100
1
1
1

M
Tobi
92
2
2
2

M
Tom
92
3
2
2

M
Sam
89
4
4
3
gender	student	score	RowNum
M	Ron	100	1
F	Mary	97	2
F	Emily	95	3
M	Tobi	92	4
M	Tom	92	5
M	Sam	89	6
F	Jennifer	89	7
F	Lori	89	8
F	Audra	84	9