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 vote155 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote189 views1 answer
Stop psql server windows
SQL
0 vote155 views1 answer
Sql check if column exists
SQL
0 vote141 views2 answers
How to get json data mysql
SQL
0 vote143 views1 answer
Formatting code with SQL Developer
SQL
51 votes256 views6 answers
Opera gx
SQL
0 vote155 views1 answer
Mysql query problems and solutions
SQL
0 vote146 views1 answer
SQL SELECT-Klausel
SQL
1 vote162 views3 answers
How to reset id column in sql server
SQL
1 vote115 views1 answer
Import in mysql without a software
SQL