Comparisons with NULL
Functions with NULL
COALESCE to the rescue
Instruction
Good. Let's do another exercise to practice the use of NULLIF.
Exercise
Show the name of each product and the column ratio 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 function round(x) to get the rounded value. There is no need to append the percent sign.
