SELECT a.weeks,COUNT(1) num FROM (SELECT WEEK(DATE_ADD(dt,INTERVAL 6 DAY),2) weeks,device_id FROM Test WHERE dt >= '2020-04-01' AND dt <= '2020-04-30') a GROUP BY a.weeks;
56,677
社区成员
56,708
社区内容
加载中
试试用AI创作助手写篇文章吧