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

2 votes439 views5 answers
Tablespace ORACLE
SQL
1 vote340 views1 answer
GROUP BY clause; this is incompati
SQL
1 vote375 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote349 views2 answers
How to list all values of a column that start with a letter in sql
SQL
13 votes358 views2 answers
Sql join
SQL
7 votes346 views2 answers
Get database size mysql
SQL
0 vote354 views1 answer
Mssql check if date is greater than today
SQL
0 vote372 views1 answer
Sql server create constraint
SQL
0 vote346 views1 answer
Mariadb maximum left join
SQL
0 vote383 views1 answer
How to generate ids in sql
SQL