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

Review
So you think you can count?
Rounding functions and more
Review and practice

Instruction

Oops! As you can see, the error occurs even if there is only a single row with a zero value in the denominator. How can we deal with this? There are a few ways to solve the problem. For now, you can use the good old WHERE clause to filter out any rows that contain a zero:

WHERE column_name != 0

We'll discuss other methods of dealing with division by zero later in our course.

Exercise

In the template you can find the query from the previous exercise. Filter out rows with 0 wisdom points.