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 votes117 views1 answer
Set sequence value oracle
SQL
0 vote117 views1 answer
Write SQL in ruby on rails
SQL
0 vote142 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
2 votes115 views1 answer
Drop table purge
SQL
0 vote130 views1 answer
Redshift running queries
SQL
0 vote106 views1 answer
Mysql money value
SQL
4 votes112 views2 answers
Mysql delete user if exists
SQL
0 vote123 views2 answers
Mysql dump database tables only
SQL
0 vote116 views1 answer
Mysql find db contarint
SQL
0 vote115 views1 answer
How to insert a uniqueidentifier in sql
SQL