第二题作答位置
区块链毕设网qklbishe.com为您提供问题的解答
第二题作答位置
SELECT a.ds, COUNT(DISTINCT a.uid) AS new_uv, COUNT(DISTINCT CASE WHEN b.ds = DATE_ADD(a.ds, INTERVAL 1 DAY) THEN a.uid END) AS retain_1, COUNT(DISTINCT CASE WHEN b.ds = DATE_ADD(a.ds, INTERVAL 7 DAY) THEN a.uid END) AS retain_7 FROM a LEFT JOIN b ON a.uid = b.uid WHERE a.ds BETWEEN '2023-05-01' AND '2023-05-31' GROUP BY a.ds ORDER BY a.ds;
20:54
以上就是关于问题第二题作答位置的答案
欢迎关注区块链毕设网-
web3一级市场套利打新赚钱空投教程
区块链NFT链游项目方科学家脚本开发培训
.jpg){kind=link}