题解 | #2021年11月每天的人均浏览文章时长#
2021年11月每天的人均浏览文章时长
http://www.nowcoder.com/practice/8e33da493a704d3da15432e4a0b61bb3
select date(out_time) as dt,round(sum(TIMESTAMPDIFF(second,in_time,out_time))/count(distinct uid),1) as avg_view_len_sec
from tb_user_log
where artical_id <>0 and DATE_FORMAT(out_time,"%Y%m")=202111
group by dt
order by avg_view_len_sec
投递腾讯等公司10个岗位 >