MySQL wiersz podsumowania

# 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  |
+------------+----------+

Dodaj komentarz