Standardizing color names

In the previous exercise, the DIFFERENCE() function was used to identify colors that closely matched our desired representation of the color GRAY. However, this approach retained a number of records where the vehicle_color value may or may not be gray. Specifically, the string GR has the same Soundex code as the string GRAY. Fortunately, records with these vehicle_color values can be excluded from the set of records that should be changed.

In this exercise, you will use see how a consistent vehicle_color value can be defined by identifying similar strings that represent the same string value. Again, the fuzzystrmatch module has already been installed for you.

Update the subquery such that the summons_number values returned exclude those from records that have GR as the vehicle_color.
Complete the UPDATE statement such that the records that have been identified as having a GRAY vehicle_color in the parking_violation table will be set to GRAY for the vehicle_color column.

Exercise

Standardizing color names

Instructions