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

3 votes361 views1 answer
Force using index oracle
SQL
0 vote361 views1 answer
Postgres row expiration
SQL
0 vote349 views1 answer
Which MySQL data type to use for storing boolean values
SQL
0 vote359 views1 answer
Fill up postgres db
SQL
0 vote340 views1 answer
Postgre admin slow
SQL
1 vote350 views1 answer
Mysql select if empty result
SQL
1 vote364 views1 answer
Oracle update with sequence
SQL
0 vote336 views1 answer
Psql no such file or directory
SQL
2 votes340 views1 answer
Mysql time ago difference
SQL
1 vote409 views1 answer
T-sql disable system versioning
SQL