2022-11-23: 分数排名。输出结果和表的sql如下。请写出输出结果的sql语句?+-------+------+| score | rank |+-------+------+| 4.00 | 1 || 4.00 | 1 || 3.85 | 2 || 3.65 | 3 || 3.65 | 3 || 3.50 | 4 |+-------+------+DROP TABLE IF EXISTS scores;CREATE TABLE scores ( id int(11) NOT NULL, score decimal(10,2) NOT NULL, PRIMARY KEY (id)) ENGINE=InnoDB DEFAULT CHARSET=latin1;INSERT INTO scores VALUES ('1', '3.50');INSERT INTO scores VALUES ('2', '3.65');INSERT INTO scores VALUES ('3', '4.00');INSERT INTO scores VALUES ('4', '3.85');INSERT INTO scores VALUES ('5', '4.00');INSERT INTO scores VALUES ('6', '3.65');