Subtract values in single column using where condition : Table Name : report
column : amount, type 
values of 'type' = credit, debit

I want to calculate balance via sum (amount) where type=credit - sum (amount) where type=debit

Please check the sqlfiddle : http://sqlfiddle.com/#!9/cd8b8c
thanks a lot !!!