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

0 vote287 views1 answer
Mssql now diff 90 day
SQL
0 vote332 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
7 votes339 views3 answers
Sql server check if temp table exists
SQL
-1 vote316 views1 answer
Brisanje dupliranih konatakata
SQL
1 vote286 views2 answers
Logical operators in sql
SQL
0 vote279 views1 answer
What is logical database schema
SQL
9 votes302 views5 answers
Sql delete duplicate rows but keep one
SQL
0 vote335 views1 answer
Parent and child link in mysql
SQL
6 votes325 views1 answer
Oracle trigger after logon on database
SQL
0 vote237 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL