Learn SQL Database Programming

Fixing rare and outlier values

Detecting rare and outlier values can help you determine if you have bad or irrelevant data. To proceed from where we left off in the detecting rare and outlier values section, execute the following query:

USE lahmansbaseballdb; SELECT DISTINCT h as hits, COUNT(h) as countFROM battingGROUP BY hitsORDER BY count;

The preceding query will give you a list of each distinct value in the h (hits) column and a count of those hits, as shown in the following two screenshots. This first screenshot shows you the beginning rows of the results:

Here, we can see that the values at the top of the results could be rare or ...