Spotting character data problems
Explore the distinct values of the street column. Select each street value and the count of the number of rows with that value. Sort the results by street to see similar values near each other.
Look at the results.
Which of the following is NOT an issue you see with the values of street?
This exercise is part of the course
Exploratory Data Analysis in SQL
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise