What is the problem with my solution?

  • 0

    Select sc1 as Score,count(sc1) as Rank from
    (Select s1.Score as sc1, s2.Score as sc2 from Scores s1, Scores s2 where s1.Score<=s2.Score group by s1.Id order by s1.Score desc) test

    my solution cannot handle table with null values (empty table)

Log in to reply

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.