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 vote199 views1 answer
Sql out file formate
SQL
0 vote186 views1 answer
Use between operator in mysql
SQL
0 vote180 views1 answer
Grepper sql workbench download
SQL
0 vote203 views1 answer
How to create a table in sql stack overflow
SQL
13 votes173 views2 answers
Sql count distinct group by
SQL
0 vote196 views1 answer
Column ' ' in field list is ambiguous
SQL
16 votes174 views2 answers
Add column to all tables after first column mysql
SQL
2 votes197 views1 answer
Node and mysql like
SQL
1 vote213 views1 answer
Postgresql not in
SQL
9 votes218 views3 answers
Date format in sql
SQL