Guest User

Untitled

a guest
Jun 24th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. SELECT
  2. D.foo,
  3. COUNT(*)
  4. FROM User U
  5. JOIN (
  6. SELECT DISTINCT DATE_FORMAT(registrationDate, '%Y-%m') as foo
  7. FROM User) as D
  8. ON DATE_FORMAT(U.registrationDate, '%Y-%m') <= D.foo
  9. GROUP BY D.foo;
Add Comment
Please, Sign In to add comment