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 vote319 views1 answer
Trigger value from maltiple table to single table mysql
SQL
4 votes314 views1 answer
Adding data to table in sql python
SQL
8 votes328 views2 answers
Grant all privileges database postgres to user
SQL
1 vote307 views2 answers
T-sql random number for each row
SQL
5 votes359 views3 answers
Sql server utc to local
SQL
11 votes334 views1 answer
Get ddl materialized view oracle
SQL
0 vote309 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
6 votes347 views2 answers
How to copy data in sql
SQL
0 vote339 views1 answer
Microsoft sql server python connection
SQL
0 vote312 views1 answer
H2 auto increment and unique
SQL