Mysql sum per week

SELECT 
  SUM(nb_like) AS nb_like, 
  CONCAT
  (
    STR_TO_DATE(CONCAT(YEARWEEK(date, 2), ' Sunday'), '%X%V %W'),
    '-',
    STR_TO_DATE(CONCAT(YEARWEEK(date, 2), ' Sunday'), '%X%V %W') + INTERVAL 6 DAY
  ) AS week
FROM fb_stats
GROUP BY YEARWEEK(date, 2)
ORDER BY YEARWEEK(date, 2);

Source: stackoverflow.com

Similar codes

0 vote361 views1 answer
Postgres regex word boundary
SQL
1 vote319 views2 answers
How to drop a unique constraint in sql
SQL
0 vote363 views1 answer
Check user sql password from command line
SQL
0 vote315 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote332 views1 answer
Set column width in sqlplus
SQL
0 vote352 views1 answer
Oracle query archive mode
SQL
0 vote347 views2 answers
Get top 1 row of each group
SQL
0 vote346 views1 answer
Ms sql print more than 1 variable
SQL
0 vote373 views1 answer
Mysql vs sql server performance benchmark
SQL
2 votes335 views1 answer
Node and mysql like
SQL