有关于一个 sql 语句错误的例子

表结构

+-------+---------------+------+-----+---------+-------+
| Field | Type          | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| SId   | varchar(10)   | YES  |     | NULL    |       |
| CId   | varchar(10)   | YES  |     | NULL    |       |
| score | decimal(18,1) | YES  |     | NULL    |       |
+-------+---------------+------+-----+---------+-------+

按照学生 SId 统计不同学生的总分数并且显示排名

我的 sql 语句

select t1.SId, t1.total_score, count(t2.total_score)+1 rank from 
(select score.SId, sum(score) total_score from score group by SId) t1 
left join 
(select score.SId, sum(score) total_score from score group by SId) t2
on t1.SId = t2.SId and t2.total_score > t1.total_score
order by rank asc

报错提示：

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 't1.SId'; this is incompatible with sql_mode=only_full_group_by

mysql 版本：5.7.30

网上说更改相关的配置就可以， 但是除了更改相关 mysql 配置还有什么办法更改 sql 语句来解决这个错误呢