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

SELECT
DATE_FORMAT(in_time, '%Y-%m-%d') AS dt,
ROUND(SUM(TIMESTAMPDIFF(second, in_time, out_time))/COUNT(DISTINCT uid), 1) AS avg_viiew_len_sec

FROM tb_user_log AS u

WHERE 
artical_id <> '0' AND
DATE_FORMAT(in_time, '%Y-%m-%d') BETWEEN '2021-11-01' AND '2021-11-30'

GROUP BY dt

ORDER BY avg_viiew_len_sec