SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE rating
(
id int,
playername varchar(100),
rating INT,
year INT
);
INSERT INTO rating VALUES(1,'A',8,2022);
INSERT INTO rating VALUES(2,'B',8,2022);
INSERT INTO rating VALUES(3,'C',0,2022);
INSERT INTO rating VALUES(4,'A',7,2020);
INSERT INTO rating VALUES(5,'B',6,2020);
INSERT INTO rating VALUES(6,'C',6,2020);
INSERT INTO rating VALUES(7,'E',5,2020);
INSERT INTO rating VALUES(8,'D',5,2020);
INSERT INTO rating VALUES(9,'D',5,2022);
9 rows affected

SELECT * FROM rating;


id
playername
rating
year


1
A
8
2022

2
B
8
2022

3
C
0
2022

4
A
7
2020

5
B
6
2020

6
C
6
2020

7
E
5
2020

8
D
5
2020

9
D
5
2022


SELECT * FROM rating ORDER BY year DESC, rating DESC;


id
playername
rating
year


1
A
8
2022

2
B
8
2022

9
D
5
2022

3
C
0
2022

4
A
7
2020

5
B
6
2020

6
C
6
2020

7
E
5
2020

8
D
5
2020

id	playername	rating	year
1	A	8	2022
2	B	8	2022
3	C	0	2022
4	A	7	2020
5	B	6	2020
6	C	6	2020
7	E	5	2020
8	D	5	2020
9	D	5	2022