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

5 votes346 views1 answer
How to get all dates in a month in oracle
SQL
1 vote318 views1 answer
Sql get missing id
SQL
0 vote305 views10 answers
John the ripper mysql
SQL
0 vote338 views1 answer
Copy Table from SQL to CSV
SQL
0 vote317 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote348 views1 answer
Postgresql using reserved word as column name
SQL
0 vote352 views1 answer
T sql dynamic top n query
SQL
1 vote342 views3 answers
Drop unique key constraint in sql server
SQL
0 vote351 views1 answer
Sql show table name in result
SQL
0 vote351 views1 answer
Longtext sql
SQL