Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
The ISNULL() function
The COALESCE() function
11. Using COALESCE() with calculations
The NULLIF() function


You can also use COALESCE() in calculations:

  COALESCE(Price, 0) * 1.05
FROM Product;

The above query will return each product's price times 1.05 (if there's a price value) or a zero if the price is NULL.


The company is giving a 10% discount on all prices. Show the names of all products, their current price, and the new discounted price. Name the new column NewPrice. If there is no price, show 0.0 in the NewPrice column.

Stuck? Here's a hint!

You can use the following piece of code to get the right price:

COALESCE(Price * 0.9, 0.0)