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

Common Functions in PostgreSQL

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.