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

7 votes227 views3 answers
Sql server check if temp table exists
SQL
0 vote206 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
23 votes184 views6 answers
How to create table in sql
SQL
3 votes188 views2 answers
Oracle sql truncate table
SQL
0 vote190 views1 answer
How to export only procedures mysql
SQL
0 vote222 views1 answer
Nodejs sql get one to many relationship as array
SQL
-1 vote207 views1 answer
Add bool column in sql
SQL
0 vote149 views2 answers
Jupyter notebook connect to database
SQL
0 vote212 views1 answer
Sql select column name like from multiple tables
SQL
3 votes149 views4 answers
Show columns from table
SQL