SQL在查询中用0替换NULL

I'm trying to replace a Null value with a 0 and then do a calculation on this field, but not able to make it work. In all 4 of the examples below I'm still getting a Null value. I'm trying to replace a Null value with a 0 and