Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > select count(distinct(sciper)) as usercount, date_format(`date`, "%Y") as year from massfacturation_old.jobs group by year;
- +-----------+------+
- | usercount | year |
- +-----------+------+
- | 160 | 2017 |
- | 262 | 2018 |
- | 165 | 2019 |
- +-----------+------+
- 3 rows in set (0.00 sec)
- > select count(distinct(sciper)) as usercount, date_format(`date`, "%Y") as year from massfacturation.jobs group by year;
- +-----------+------+
- | usercount | year |
- +-----------+------+
- | 170 | 2019 |
- +-----------+------+
- 1 row in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement