# 178. 分数排名
# https://leetcode-cn.com/problems/rank-scores/

# SQL架构
Create table If Not Exists Scores (id int, score DECIMAL(3,2));
Truncate table Scores;
insert into Scores (id, score) values ('1', '3.5');
insert into Scores (id, score) values ('2', '3.65');
insert into Scores (id, score) values ('3', '4.0');
insert into Scores (id, score) values ('4', '3.85');
insert into Scores (id, score) values ('5', '4.0');
insert into Scores (id, score) values ('6', '3.65');

# Write your MySQL query statement below
select
    score,
    dense_rank() over (
        order by
            score desc
    ) as 'rank'
from
    Scores;

# clean-up
drop table Scores;