题解 | #2021年11月每天的人均浏览文章时长#

-- 统计2021年11月，每天，人均浏览时长，秒数，1为小数，排序
select date(in_time) dt,
round(sum(timestampdiff(second,in_time,out_time))/count(distinct uid),1) avg_viiew_len_sec
from tb_user_log 
where datediff(in_time,'2021-11-01') >= 0
and datediff(in_time,'2021-11-30') <= 0
and datediff(out_time,'2021-11-01') >= 0
and datediff(out_time,'2021-11-30') <= 0
and artical_id != 0
group by date(in_time)
order by avg_viiew_len_sec ASC