题解 | #用户每月最后一周的练题数#

select device_id, date_format(event_date,'%Y年%m月') ym,count(device_id) cnt 
from question_practice_detail
where datediff(last_day(event_date),event_date) < 7
group by ym, device_id
order by device_id,ym