# Write your MySQL query statement below SELECT s1.score as Score, #s2表中有分数大于等于排序后的s1表中的分数就代表排名是多少 (SELECT COUNT(DISTINCT s2.score) FROM Scores s2 WHERE s2.score>=s1.score) AS `Rank` FROM Scores s1 ORDER BY s1.score DESC;
2023-12-13 09:49:21
# Write your MySQL query statement below SELECT s1.score as Score, #s2表中有分数大于等于排序后的s1表中的分数就代表排名是多少 (SELECT COUNT(DISTINCT s2.score) FROM Scores s2 WHERE s2.score>=s1.score) AS `Rank` FROM Scores s1 ORDER BY s1.score DESC;