题解 | #统计自然周平均登录次数情况#
关键在于自然周 周一 ：①date_sub() ②weekday()
select date_sub(login_date,interval weekday(login_date) day) as week_begin, round(count(uid)/count(distinct uid),2) as avg_times from user_login_tb group by week_begin order by week_begin
，不说了，我又接了一单