MySQL snippet to group records by week.

SELECT COUNT(*), DATE_ADD(DATE(`orders`.`date`), INTERVAL (7 - DAYOFWEEK(`orders`.`date`)) DAY) AS `week_end` FROM `orders` GROUP BY `week_end`;