Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Standard SQL Functions

Review
Comparisons with NULL
Functions with NULL
COALESCE to the rescue
NULLIF
21. NULLIF – practice 1
Review and practice

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.