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 votes132 views2 answers
Enable foreign key checks postgres
SQL
4 votes123 views2 answers
Postgres update single column
SQL
1 vote133 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
1 vote148 views2 answers
Oracle leftmost characters
SQL
0 vote133 views1 answer
How to reset table in sql server
SQL
4 votes262 views1 answer
Oracle table statistics
SQL
2 votes133 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote165 views1 answer
Cannot start database server xampp mac os
SQL
0 vote155 views3 answers
Join
SQL
3 votes219 views1 answer
Oracle show trigger code
SQL