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

4 votes179 views1 answer
Conda install sqlalchemy
SQL
0 vote183 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
2 votes210 views1 answer
Match in sql server
SQL
3 votes170 views2 answers
Oracle sql drop sequence
SQL
0 vote168 views1 answer
Connexion mysql
SQL
0 vote189 views2 answers
SQL Server Standard
SQL
15 votes173 views2 answers
Open postgress in terminal mac
SQL
15 votes176 views3 answers
Find duplicate keys in mysql
SQL
1 vote168 views1 answer
Get table column names sql ssms
SQL
1 vote173 views1 answer
Adding a default constraint to an existing column in sql
SQL