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

1 vote113 views1 answer
Mysql size int
SQL
0 vote116 views1 answer
Add sqlite3 in lumen
SQL
0 vote110 views1 answer
Dbms_output sql developer
SQL
0 vote114 views2 answers
Mysql multiply
SQL
1 vote138 views1 answer
Oracle columns table
SQL
1 vote119 views1 answer
Oracle apex version view
SQL
3 votes119 views3 answers
Restart mysql mac
SQL
0 vote127 views1 answer
How to inner join 4 tables in sql
SQL
0 vote120 views1 answer
How to find total working hour in sql
SQL
3 votes113 views3 answers
How to add month in update sql
SQL