mysql 按周分组查询

    select date,DATE_FORMAT(date,'%Y%m') weeks,sum(`install`) install_count,sum(`launches`) launches_count,sum(`active`) active_count from tj_app_day_data where date >='2017-10-25' and date<='2017-12-17' group by weeks;