求一SQL语句

[itotech]

表A
LB JE DATA
1 1.00 2018-02-01 12:11:10
1 2.00 2018-02-01 13:02:03
2 1.00 2018-02-01 16:01:01
2 3.00 2018-02-01 18:09:25
1 1.00 2018-02-02 14:01:07
1 1.00 2018-02-02 19:03:02
2 1.00 2018-02-02 18:09:07
1 1.00 2018-02-03 08:02:58

要得到返回列表
LB JE DATA
1 3.00 2018-02-01
2 4.00 2018-02-01
1 2.00 2018-02-02
2 1.00 2018-02-02
1 1.00 2018-02-03

就是按天数统计 group by date_format(DATA,'%Y-%m-%d') 再按group by LB SUM(JE)
合在一起的语句怎么写？

[砸死牛顿的苹果]

你自己不是都写出来了 select LB,SUM(JE),date_format(DATA,'%Y-%m-%d') as `DATE` from tb group by LB,date_format(DATA,'%Y-%m-%d')

[rucypli]

select date(DATA),LB,sum(JE) from tb group by date(DATA),LB

[Rotel-刘志东]

SELECT lb,DATE(data)data,SUM(je) from tb group by Date(Data),lb