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

7 votes274 views3 answers
Select latest entry in sql table
SQL
1 vote272 views1 answer
Sqlite show columns in table
SQL
1 vote284 views2 answers
How to combine 2 tables in MySQL
SQL
3 votes275 views2 answers
How to modify rows in SQL Server
SQL
2 votes258 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
3 votes283 views1 answer
Laravel database Using Named Bindings
SQL
0 vote265 views1 answer
Sql server python connection
SQL
0 vote291 views1 answer
Migration graphql
SQL
6 votes311 views6 answers
Rename column postgres
SQL
0 vote300 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL