這個表，我想查詢出來左邊是從大到小排列 右邊是排名。我這么寫的語句為什么不對啊，?select?score,(select?count(*)?from?(select?distinct?score?from?scores?group?by?score?order?by?score?desc)?as?s2?where?s1.score?>=?s2.score)?as?rank ?from?(select?distinct?score?from?scores??order?by?score?desc)?as?s1這是報錯：