mysql 分组查询和统计

ID   EventNo   Coin   Uid   FlowNo
1    600041    30     1     1531238400000000000
2    600041    30     2     1531238400000000000
...

select EventNo, Count(ID),Sum(Coin),count(distinct(Uid)) from CoinFlow where FlowNo>1531238400000000000 and FlowNo<1531324800000000000 group by EventNo;