I want sum of payment status from two differnt columns based on paymentstatus value - but this query returns null for sum. Why is it not working?

```
select payment_status,
CASE 
WHEN 'PAID' THEN sum(paid_amount)
when 'Not Paid' then sum(total_amount_due )
END 
from monthly_fee
group by payment_status;

```