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 vote387 views1 answer
How to inner join 4 tables in sql
SQL
0 vote343 views1 answer
How to concatenate text from multiple rows into a single text string in SQL Server
SQL
0 vote341 views1 answer
Sql create table with datetime automatically
SQL
0 vote347 views1 answer
Postgresql array to rows
SQL
0 vote343 views1 answer
Learn sqlite dart
SQL
1 vote360 views1 answer
Oracle create_program
SQL
0 vote324 views1 answer
Get duplicate entry sql
SQL
0 vote356 views1 answer
Sql where part of string match
SQL
2 votes410 views1 answer
Sql find not in list
SQL
0 vote338 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL