Find Outliers in SQL | Data Analyst SQL Interview Question
Use standard deviation and the empirical rule to find outliers that are above and below your 68,95,99.7 percentile which are within 1, 2 and 3 standard deviation respectively from the mean.
Find outliers using the Z-score Watch the video:
• Find Outliers in SQL