Guest User

Untitled

a guest
Jul 17th, 2018
142
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. mysql> select count(*) from subscribers where status = 'new' and activated_at <= '2009-11-16';
  2. +----------+
  3. | count(*) |
  4. +----------+
  5. | 43669 |
  6. +----------+
  7. 1 row in set (0.88 sec)
  8.  
  9. mysql> select count(*) from subscribers where status = 'new' and activated_at = '2009-11-16';
  10. +----------+
  11. | count(*) |
  12. +----------+
  13. | 8 |
  14. +----------+
  15. 1 row in set (0.87 sec)
Add Comment
Please, Sign In to add comment