Check out the solution in the video TSQL: How To Get the Outliers In A Data Set. We often hear about generalizations and exceptions when discussing data (outside of statistics, these are common terms). Generalizations are generally true: they are the tendency (synonyms may include normal or expected behavior). Exceptions are rare - they are outside the tendency (synonyms may be abnormal or unexpected behavior).
In the below course related to ETL, I provide two different examples in practice of using the outliers to solve problems (one of which is becoming a major problem for parents). These are always huge opportunities when you come across them, so students benefit from learning about these opportunities along with tools to automatically find them.
Check out the highest-rated Automating ETL course on Udemy, if you're interested in data.
In this video, we look at how to obtain the outliers in a data set using T-SQL. I also address the question about whether we will always use the same base number and how to determine if we should switch that. Pay close attention as this matters more than you'd think.
YouTube | Automating ETL | T-SQL In 2 Hours | Consumer Guide To Digital Security