SQL IFNull

Table Sales_Data

store_name	Sales
Store A	300
Store B	NULL

 
The following SQL,
 
SELECT SUM(IFNULL(Sales,100)) FROM Sales_Data;
returns 400. This is because NULL has been replaced by 100 via the IFNULL function.