使用SQL根据日期计算总和的最佳方法

I don't know a good way to maintain sums depending on dates in a SQL database.I don't know a good way to maintain sums depend