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

15 votes177 views2 answers
Sql order by multiple columns
SQL
3 votes171 views2 answers
Check data in table mysql
SQL
0 vote172 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote179 views1 answer
Power bi union columns
SQL
0 vote186 views1 answer
How to set up an anonymous function to variable in swift
SQL
17 votes166 views6 answers
Mysql import sql file
SQL
4 votes175 views2 answers
Postgresql default value
SQL
0 vote167 views1 answer
Multiple tricky query in sql server
SQL
-1 vote144 views1 answer
Mysql if example
SQL
10 votes178 views3 answers
How to fetch first 5 characters in sql
SQL