1308 不同性别每日分数总计

题目描述：

写一条SQL语句查询每种性别在每一天的总分，并按性别和日期对查询结果排序
下面是查询结果格式的例子：

方法1:
主要思路：解题链接汇总

select s1.gender as gender, s1.day as day, sum(s2.score_points) as total
from Scores as s1 join Scores as s2 on s1.gender = s2.gender
where s1.day>=s2.day 
group by s1.gender,s1.day
order by s1.gender,s1.day