SELECT
  test_table.arrangement_id,
  credit.credit_amount_sum AS credit_sum,
  debit.debit_amount_sum   AS debit_sum
FROM test_table
  LEFT JOIN (
              SELECT
                arrangement_id,
                SUM(amount) AS credit_amount_sum
              FROM test_table
              WHERE credit_debit_indicatintor = 'credit'
              GROUP BY arrangement_id
            ) credit ON credit.arrangement_id = test_table.arrangement_id
  LEFT JOIN (
              SELECT
                arrangement_id,
                SUM(amount) AS debit_amount_sum
              FROM test_table
              WHERE credit_debit_indicatintor = 'debit'
              GROUP BY arrangement_id
            ) debit ON debit.arrangement_id = test_table.arrangement_id
WHERE credit_amount_sum > debit_amount_sum
GROUP BY test_table.arrangement_id