WITH RankedStudents AS ( SELECT id, name, score, RANK() OVER (ORDER BY score DESC) AS student_rank FROM scores ) SELECT name FROM RankedStudents WHERE student_rank = 2;