Posted By

Tagged

1 person have marked this snippet as a favorite

/ Published in: SQL

Using MySQL you can group date data by week. This is much easier than trying to add up the daily values for each week in a code loop.

SELECT join_date AS week, count(*) AS signups 
FROM users 
GROUP BY week(join_date);

Comment:

You need to login to post a comment.