最近应用到一天充值的统计
比如跟下表 需求汇总每天每个页面进入的成功充值额total，与充值人数num，充值人次people
(人数跟人次的区别就像PV与UV的区别,同一个人可以充值n次，人数为1,人次为n)
status 1 充值成功 0失败
表类似:
Id | uid | money | page | status | date |
1 | 2 | 300 | Index | 0 | 20140409 |
2 | 3 | 400 | Index | 1 | 20140409 |
3 | 2 | 500 | Content | 1 | 20140409 |
4 | 4 | 900 | Content | 0 | 20140409 |
5 | 3 | 200 | Content | 1 | 20140409 |
语句：
SELECTCOUNT(distinct uid) as num,COUNT(1) as people,SUM(case when status=1then money end) as total group by date,page
原文：http://aarons.blog.51cto.com/2383032/1395752