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 vote231 views1 answer
How to check all scheduled jobs in oracle
SQL
17 votes183 views4 answers
Mysql remove ubuntu
SQL
0 vote165 views1 answer
Truncate table sql server foreign key
SQL
1 vote166 views1 answer
Postgres count string length
SQL
1 vote157 views1 answer
Sql auto timestamp
SQL
0 vote165 views1 answer
Postgres float to int
SQL
1 vote176 views1 answer
Mysql data from file
SQL
0 vote204 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote183 views1 answer
Kill slow queries mysql
SQL
11 votes187 views5 answers
Laravel db facade
SQL