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

1 vote265 views1 answer
Sample clause in sql
SQL
1 vote271 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote268 views2 answers
Plsql regex match whole word
SQL
6 votes282 views2 answers
Oracle trigger
SQL
0 vote282 views2 answers
Greater than sql server
SQL
18 votes226 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote258 views1 answer
Porcentaje sql
SQL
9 votes253 views2 answers
Get first 3 letters in sql
SQL
1 vote266 views4 answers
Mysqldump 1 table only
SQL
-1 vote288 views1 answer
Create view in mysql workbench
SQL