Autumn Offers - hours only!Up to 80% off on all courses and bundles.-Close
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.