Advertisement
Guest User

Untitled

a guest
Jan 16th, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.54 KB | None | 0 0
  1. SELECT date_trunc('week', users.created_at) AS "Week" , count(*) AS "No. of created users"
  2. FROM users
  3. WHERE users.created_at > now() - interval '12 months'
  4. GROUP BY 1
  5. ORDER BY 1;
  6.  
  7. | Week | No. Created Users | Created without email | Created without last name |
  8.  
  9. | 2016-01-04 | 200 | 85 | 12 |
  10.  
  11. | 2016-01-11 | 400 | 93 | 29 |
  12.  
  13. | 2016-01-18 | 150 | 84 | 12 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement