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

8 votes216 views1 answer
Mysql limit rows
SQL
17 votes331 views4 answers
Show all tables in oracle
SQL
0 vote279 views1 answer
Sql filter rows with condition
SQL
6 votes272 views2 answers
Mysql check auto increment value
SQL
19 votes246 views5 answers
Display table in sql
SQL
0 vote206 views1 answer
Pgadmin see indexes
SQL
0 vote183 views1 answer
Get who is hired in month in sql
SQL
0 vote201 views2 answers
Update all linkedserver tables with openquery on db
SQL
3 votes204 views1 answer
Sql cast to integer
SQL
0 vote235 views1 answer
Duplicate value unique constraint mysql error
SQL