DROP TABLE grouped_transactions;
CREATE TEMPORARY TABLE grouped_transactions AS (SELECT sender_id, recipient_id, operation_id, sum(amount_value), amount_currency_code from billing_transactions group by sender_id, recipient_id, operation_id, amount_currency_code);
TRUNCATE billing_transactions;
INSERT INTO billing_transactions (sender_id, recipient_id, operation_id, created_at, updated_at, amount_value, amount_currency_code)
    select sender_id, recipient_id, operation_id, now(), now(), `sum(amount_value)`, amount_currency_code from grouped_transactions;