Breaking News: Grepper is joining You.com. Read the official announcement!

mysql sum per week

vnxx answered on September 5, 2021 Popularity 3/10 Helpfulness 1/10

answer mysql sum per week

mysql sum per week

Comment

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);

Popularity 3/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: mysql sql sum

Link to this answer
Share Copy Link