反馈
反馈
2023-09-14 09:15:49 时间
with rank as(
SELECT group_id, SUM(pay_dollar) as pay_dollars, count(*) as count FROM
(select mod(player_id, 33) as group_id, pay_amount*exchange as pay_dollar FROM mafia1.offer_purchase
WHERE timestamp >='2019-10-21 12:10:00' and timestamp <='2019-10-22 18:50:00' and player_id not in (select player_id FROM mafia1.create_player where uid in (select uid from mafia1.internal_user)))
# and player_id in (select player_id FROM mafia1.create_player where timestamp >='2019-07-01'))
#where pay_dollar >=90
group by group_id
order by pay_dollars)
select group_id, pay_dollars/total_dollars as ratio, count, pay_dollars, pay_dollars/count as mean FROM rank, (select SUM(pay_dollars) as total_dollars FROM rank)
Order by pay_dollars
Index(['10904', '10648', '10225', '8532', '7595', '8518', '8538', '10393',
'11347', '9108',
...
'11081', '8452', '7378', '10889', '11099',
'91ift0698775""""speedup_ops_25"":1', '10890', '10409', '9856',
'10506'],
with rank as(
SELECT group_id, SUM(pay_dollar) as pay_dollars, count(*) as count FROM
(select mod(player_id, 33) as group_id, pay_amount*exchange as pay_dollar FROM mafia1.offer_purchase
WHERE timestamp >='2019-10-23 13:15:00' and timestamp <='2019-10-23 23:50:00' and player_id not in (select player_id FROM mafia1.create_player where uid in (select uid from mafia1.internal_user)))
# and player_id in (select player_id FROM mafia1.create_player where timestamp >='2019-07-01'))
#where pay_dollar >=90
group by group_id
order by pay_dollars)
select group_id, pay_dollars/total_dollars as ratio, count, pay_dollars, pay_dollars/count as mean FROM rank, (select SUM(pay_dollars) as total_dollars FROM rank)
Order by pay_dollars
with rank as(
SELECT group_id, SUM(pay_dollar) as pay_dollars, count(*) as count FROM
(select mod(player_id, 33) as group_id, pay_amount*exchange as pay_dollar FROM mafia1.offer_purchase
WHERE timestamp >='2019-10-19 03:00:00' and timestamp <='2019-10-23 23:50:00' and player_id not in (select player_id FROM mafia1.create_player where uid in (select uid from mafia1.internal_user)))
# and player_id in (select player_id FROM mafia1.create_player where timestamp >='2019-07-01'))
#where pay_dollar >=90
group by group_id
order by pay_dollars)
select group_id, pay_dollars/total_dollars as ratio, count, pay_dollars, pay_dollars/count as mean FROM rank, (select SUM(pay_dollars) as total_dollars FROM rank)
Order by pay_dollars
相关文章
- 研究人员发现短暂延迟的神经反馈有助于顶叶α节律的训练
- 【Verilog】移位寄存器总结:移位寄存器、算数移位寄存器、线性反馈移位寄存器(LFSR)
- NIPS'21「微信」推荐系统:结合课程学习的多反馈表征解耦
- MOTOROLA 30-W2960B01A 基于反馈的自动化流程调整
- “码”上反馈,自动留痕:二维码助力人居环境巡查高效化
- 多级反馈队列调度算法详解
- Win10部分用户反馈KB5003173更新失败:跳0x800f0922错误
- 库克:应用追踪透明度政策带来了积极的客户反馈
- AR中虚拟物体也有触觉反馈?有人想把这项技术与HoloLens结合
- android+json+php+mysql实现用户反馈功能方法解析