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

Instruction

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

Exercise

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.