1
You can use ISNULL function, if value is null it display 0
ISNULL(columnName, 0)
For further reference:
http://stackoverflow.com/questions/16667148/instead-of-null-how-do-i-show-0-in-result-with-select-statement-sql
Do let me know if it solves your problem.