1. Learn
    2. /
  2. Courses
    3. /
  3. Reporting in SQL

Exercise

Troubleshooting CASE statements

In the previous exercise, you may have noticed several null values in our case statement, which can indicate there is an issue with the code.

In these instances, it's worth investigating to understand why these null values are appearing. In this exercise, you will go through a series of steps to identify the issue and make changes to the code where necessary.

Instructions 1/3

undefined XP
    1
    2
    3
  • Comment out the query from last exercise (lines 2 - 12).
  • Create a query that pulls height, weight, and bmi from athletes and filters for null bmi values.