SELECT date_trunc('week', users.created_at) AS "Week" , count(*) AS "No. of created users" FROM users WHERE users.created_at > now() - interval '12 months' GROUP BY 1 ORDER BY 1; | Week | No. Created Users | Created without email | Created without last name | | 2016-01-04 | 200 | 85 | 12 | | 2016-01-11 | 400 | 93 | 29 | | 2016-01-18 | 150 | 84 | 12 |