您可以使用与我之前的回答类似的查询，并更改 table1 为了便于按日期分组：

select coalesce(credit_date, debit_date, loan_date) as date, 
       coalesce(sum(credit_amount), 0) as credit_payment, 
       coalesce(sum(debit_amount), 0) as debit_payment,
       coalesce(sum(loan_amount), 0) as loan_payment,
       entity, currency, owner,
       coalesce(sum(credit_amount), 0) + coalesce(sum(debit_amount), 0) + coalesce(sum(loan_amount), 0) as Total
from (
    select credit_date, credit_amount, null as debit_date, null as debit_amount, null as loan_date, null as loan_amount, entity, currency, owner
    from table1
    union all
    select null as credit_date, null as credit_amount, debit_date, debit_amount, null as loan_date, null as loan_amount, entity, currency, owner
    from table1
    union all
    select null as credit_date, null as credit_amount, null as debit_date, null as debit_amount, loan_date, loan_amount, entity, currency, owner
    from table1
) t
group by coalesce(credit_date, debit_date, loan_date), entity, currency, owner