Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. > select count(distinct(sciper)) as usercount, date_format(`date`, "%Y") as year from massfacturation_old.jobs group by year;
  2. +-----------+------+
  3. | usercount | year |
  4. +-----------+------+
  5. | 160 | 2017 |
  6. | 262 | 2018 |
  7. | 165 | 2019 |
  8. +-----------+------+
  9. 3 rows in set (0.00 sec)
  10.  
  11. > select count(distinct(sciper)) as usercount, date_format(`date`, "%Y") as year from massfacturation.jobs group by year;
  12. +-----------+------+
  13. | usercount | year |
  14. +-----------+------+
  15. | 170 | 2019 |
  16. +-----------+------+
  17. 1 row in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement