Or we can use the COALESCE() function, like this:
SELECT ProductName, UnitPrice * (UnitsInStock + COALESCE(UnitsOnOrder, 0))
FROM Products;
FROM Products;
Practice Excercise Practice now
Or we can use the COALESCE() function, like this:
Practice Excercise Practice now