SELECT
app_code,
report_date,
period,
"indicator",
users,
times,
sum(times)over(partition by report_date,period) sums,
TYPE
FROM
summary.mini_statistics
WHERE
report_date = CURRENT_DATE - 1
AND period = 1
AND app_code = 'shadoubao'
AND "type" = 'A'
AND (
INDICATOR LIKE 'enter_%'
OR INDICATOR = '进入首页'
)
ORDER BY
users
这里用over(partition by )根据筛选条件求和
shadoubao 2018-12-20 1 enter_招商 25 46 1510 A
shadoubao 2018-12-20 1 enter_邀请好友页面 35 257 1510 A
shadoubao 2018-12-20 1 enter_名片 44 114 1510 A
shadoubao 2018-12-20 1 enter_消息 67 108 1510 A
shadoubao 2018-12-20 1 enter_计划书列表 75 165 1510 A
shadoubao 2018-12-20 1 enter_产品对比 147 440 1510 A
shadoubao 2018-12-20 1 进入首页 291 380 1510 A