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 vote253 views1 answer
How to install mysql without admin rights
SQL
0 vote240 views1 answer
Sql query with date
SQL
11 votes265 views1 answer
Oracle view source
SQL
0 vote251 views1 answer
Oracle list proxy users
SQL
0 vote255 views1 answer
Mysql error 1251
SQL
0 vote268 views1 answer
Select nth row in mysql
SQL
25 votes292 views4 answers
Import mysql dump command line
SQL
0 vote247 views1 answer
Limiting query result using where in sql
SQL
-2 votes272 views2 answers
Union all in sql
SQL
0 vote265 views1 answer
How to alter length character varying postgres
SQL