===== Вкупно потрошено во тековниот месец за цел систем Вкупна сума на трошоци во тековниот месец {{{#!sql SELECT SUM(tb.spent_amount) AS total_spent FROM transaction_breakdown tb JOIN transaction t ON tb.transaction_id = t.transaction_id WHERE EXTRACT(MONTH FROM t.date) = EXTRACT(MONTH FROM CURRENT_DATE) AND EXTRACT(YEAR FROM t.date) = EXTRACT(YEAR FROM CURRENT_DATE); }}}