# SELECT DATE(created) AS data, SUM(price) AS przychod FROM transactions GROUP BY data WITH ROLLUP;
+------------+----------+
| data | przychod |
+------------+----------+
| 2019-06-10 | 406.00 |
| 2019-06-11 | 612.00 |
...................
| 2019-06-19 | 987.00 |
| 2019-06-21 | -3.00 |
| NULL | 7617.00 |
+------------+----------+