WITH RankedStudents AS ( SELECT student_id, name, score, DENSE_RANK() OVER (ORDER BY score DESC) AS dense_rank FROM students WHERE gender = '男' ) SELECT student_id, name, score, dense_rank FROM RankedStudents WHERE dense_rank <= 10;