Closed hooopo closed 1 year ago
for example:
SELECT DATE_SUB(DATE(starred_at), INTERVAL WEEKDAY(starred_at) DAY) AS week_beginning, COUNT(*) as stars FROM starred_repos WHERE starred_at >= DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY) GROUP BY week_beginning ORDER BY week_beginning ASC;
related to #127
for example: