- MariaDB [sarjuuk_sn]> SELECT count(1) AS 'total per', DATE_FORMAT(`created_at`, '%d.%m.%y') AS 'day' FROM capsules GROUP BY `day` ORDER BY `created_at` ASC;
- +-----------+----------+
- | total per | day |
- +-----------+----------+
- | 1 | 10.01.18 |
- | 16680 | 24.01.18 |
- | 11140 | 25.01.18 |
- | 9379 | 26.01.18 |
- | 10996 | 27.01.18 |
- | 10054 | 28.01.18 |
- | 6571 | 29.01.18 |
- | 4337 | 30.01.18 |
- | 4111 | 31.01.18 |
- | 4135 | 01.02.18 |
- | 4546 | 02.02.18 |
- | 5844 | 03.02.18 |
- | 6327 | 04.02.18 |
- | 4247 | 05.02.18 |
- | 3722 | 06.02.18 |
- | 3752 | 07.02.18 |
- | 3509 | 08.02.18 |
- | 3687 | 09.02.18 |
- | 5080 | 10.02.18 |
- | 5396 | 11.02.18 |
- | 3657 | 12.02.18 |
- | 3063 | 13.02.18 |
- | 2882 | 14.02.18 |
- | 2774 | 15.02.18 |
- | 5037 | 16.02.18 |
- | 4864 | 17.02.18 |
- | 4274 | 18.02.18 |
- | 3249 | 19.02.18 |
- | 2894 | 20.02.18 |
- | 3374 | 21.02.18 |
- | 2929 | 22.02.18 |
- | 3166 | 23.02.18 |
- +-----------+----------+
- 32 rows in set (0.13 sec)