Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement