Write an SQL query to rank the scores. The ranking should be calculated according to the following rules:
Return the result table ordered by score in descending order.
The query result format is in the following example.
 
Example 1: