SELECT
COUNT(*) AS reports_in_week,
DATE_ADD(created_at, INTERVAL(1-DAYOFWEEK(created_at)) DAY) as start_day,
DATE_ADD(created_at, INTERVAL(7-DAYOFWEEK(created_at)) DAY) as end_day
FROM
your_table_name
GROUP BY
YEAR(created_at) + .01 * WEEK(created_at)
The desired output will be.
awesome !!
ReplyDeleteGood one..
ReplyDelete