Guest User

Untitled

a guest
May 22nd, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.18 KB | None | 0 0
  1. SELECT COUNT(_id) AS orders, customer__email
  2. FROM
  3. ENTER_YOUR_DB_NAME.orders
  4. WHERE
  5. customer__email IS NOT NULL
  6. GROUP BY
  7. customer__email
  8. ORDER BY
  9. orders DESC
Add Comment
Please, Sign In to add comment