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 votes144 views2 answers
Mysqldump password
SQL
0 vote148 views1 answer
How to get inserted id in sql server
SQL
0 vote171 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote158 views1 answer
Sql script to remove default from column
SQL
0 vote157 views1 answer
T-SQL Never ending DELETE
SQL
0 vote145 views1 answer
Min mysql
SQL
0 vote137 views1 answer
Call function sql oracle
SQL
0 vote170 views2 answers
Sql stored procedure for access frontend
SQL
-1 vote140 views1 answer
How to format tables in sqlplus
SQL
0 vote161 views2 answers
Temp Space
SQL