按周/月间隔的日期范围分组

SELECt WEEKOFYEAR(`date`) AS period, SUM(clicks) AS clicksFROM `tablename`WHERe `date` >= CURDATE() - INTERVAL 4 WEEKGROUP BY periodSELECt MonTH(`date`) AS period, SUM(clicks) AS clicksFROM `tablename`WHERe `date` >= CURDATE() - INTERVAL 3 MonTHGROUP BY period