Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
The COALESCE() function
The GREATEST() & LEAST() functions
The NULLIF() function
13. Practice NULLIF() – 1


Good! Let's do another exercise to practice the use of the NULLIF() function.


Show the name of each product and the ratio column calculated in the following way: the price of each product in relation to its shipping_cost in percent, rounded to an integer value (e.g., 31).

If the shipping cost is 0.00, show NULL instead.

Stuck? Here's a hint!

Use the ROUND(x) function to get the rounded value.