We look at median overall and with T-SQL in What Is Median? Why Use Median?. As you can see, we see one way in which we can obtain the median using T-SQL. We also notice a comparison of average versus median and how this impacts data sets: in the example, the median figure may be 0 while the average figure may be five figures. How can this be?
Check out the highest-rated Automating ETL course on Udemy, if you're interested in data.
While outliers can affect average, they seldom have an impact on median. Median's underlying measurement won't be swayed by outliers and we seldom have data sets where all of our data values lie on either tail of the bell curve (like all data sets being left or right-tailed).