我有table

account_no | name | date        | amount 
1101       |   A  |  2018-11-20 |  50
1101       |   A  |  2018-11-20 |  20
1102       |   B  |  2018-11-20 |  30    
1101       |   A  |  2018-11-19 |  100
1101       |   A  |  2018-11-18 |  80
1102       |   B  |  2018-11-19 |  70

我想要以下输出

account_no | name  | group(today) | group(month)
1101       |   A   |     70       |  250 
1102       |   B   |     30       |  100

不是我得到今天的总数就是一个月的总数不是一排都是。到目前为止我试过的

select account_no, sum(today) from account group by account_no having date = '<today>'

select account_no, sum(today) from account group by account_no having date between '<firstDay>' and '<today>'

我可以考虑使用union，但不能给出重复的行。