数据表为：

日期                          收入

2017-04-01                     30

2017-04-01                     20

2017-04-01                     25

2017-04-02                    30

2017-04-02                    26

2017-04-03                    30

2017-04-04                    35

2017-04-04                    25

2017-04-05                     30

2017-04-05                     28

2017-04-05                     20

2017-04-06                     23

2017-04-06                     32

2017-04-06                     29

现在要输出每天的总收入

2017-04-01总收入:

2017-04-02总收入:

2017-04-03总收入:

2017-04-04总收入:

2017-04-05总收入:

2017-04-06总收入:

请问sql语句怎么写