scoring system

SELECT ID, NAME, SCORE FROM

(

  SELECT 

      ID, 

      NAME, 

      SCORE,  

      DENSE_RANK() OVER (ORDER BY SCORE DESC) AS DenseRank 

  FROM STUDENT

) DT

 WHERE DenseRank < 4

 ORDER BY SCORE DESC, ID ASC;