sum of sum
Hi everyone.
Good day.
I have a table 'payments' with 9 fields.
id,
client_name,
total_amount,
deposit_paid,
deposit_paid_on_date,
1st_installment,
installment_paid_on_date,
2nd_installment_paid,
2nd_installment_paid_on_date
I want to get the the sum of each payment, for which I have used the 'sum()' in the query.
But how can I get the sum of the sum (deposit_paid + 1st_installment + 2nd_installment) received today.
Regards.
|