SQL个人笔记——社区内容发帖数据统计逻辑总结
====================帖子内容相关数据===========================
--1-10月发帖量和发帖人数统计
select
trunc(a.day,'MM') as month
,count(distinct a.tid) as tid_num
,count(distinct a.openid) as uv
,count(a.openid) as pv
from
(
--发帖新口径
select
...
原创
2020-11-06 21:30:38 ·
284 阅读 ·
0 评论