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

Exercise

Interpreting error messages

Inevitably, you will run into errors when running SQL queries. It is important to understand how to interpret these errors to correctly identify what type of error it is.

The console contains two separate queries, each which will output an error when ran. In this exercise, you will run each query, read the error message, and troubleshoot the error.

Instructions 1/2

undefined XP
  • 1
    • Run the query in the console.
    • After reading the error, fix it by converting the data type to float.
  • 2
    • Comment the first query and uncomment the second query.
    • Run the code and fix errors by making the join columns int.