CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT
- t1.id,
- SUM(t1.amount) AS amount,
- SUM(t1.amount > 0) AS amount_plus,
- SUM(t1.amount < 0) AS amount_minus
- FROM `my_table` AS t1
- WHERE (bla-bla-bla)
- GROUP BY CONCAT(t1.month_fix,'-',t1.year_fix)
- ORDER BY t1.month_fix ASC