Mysql Case sum

select sum(CASE WHEN payment_status = 'PAID' THEN paid_amount else 0 end) as paid,
       sum(CASE WHEN payment_status = 'Not Paid' THEN total_amount_due else 0 end) as due
from monthly_fee

Source: stackoverflow.com

Similar codes

4 votes217 views1 answer
Check database name postgresql
SQL
57 votes341 views6 answers
Sql alter table
SQL
2 votes225 views1 answer
Anonymous block plsql
SQL
0 vote220 views1 answer
Shell script to log mysql cpu usage
SQL
6 votes225 views2 answers
Database url postgres
SQL
0 vote265 views1 answer
How to change mysql root password in windows 10
SQL
31 votes212 views3 answers
Sql count(*)
SQL
0 vote189 views1 answer
Query for maximum salary
SQL
1 vote244 views1 answer
Sql order by where condition
SQL
0 vote225 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL