Session Ready
Exercise

Matching inconsistent color names

From the sample of records in the parking_violations table, it is clear that the vehicle_color values are not consistent. For example, GRY, GRAY, and GREY are all used to describe a gray vehicle. In order to consistently represent this color, it is beneficial to use a single value. Fortunately, the DIFFERENCE() function can be used to accomplish this goal.

In this exercise, you will use these functions to return records that contain a vehicle_color value that closely matches the string GRAY. The fuzzystrmatch module has already been enabled for you.

Instructions
100 XP
  • Complete the query below to return records with Soundex vehicle_color codes matching the Soundex code of the string GRAY using the DIFFERENCE() function.