How to use SQL to Calculate the Median | Essential SQL

Joins have got you confused. Then let’s get that fixed! Check out Join Together Now! https://www.udemy.com/course/join-together-now-write-t-sql-joins-using-sql-server/?couponCode=YOUTUBE202210 You need to calculate the Median using SQL, but one problem! There isn't a MEDIAN() function like there is AVERAGE(). So what do you do? Don't worry! In this video I'll show you how you can use a little used window function PERCENTILE_CONT() to calculate the median. One Last Thing... This video is part of my Intermediate Learning series. If you're interested in learning SQL subscribe to @Essential SQL and then check out our Intermediate Learner Playlist. Of course, I also encourage you to visit https://www.essentialsql.com to learn even more! Most Business Analysts don’t know where to start learning SQL. At Essential SQL we have an easy-to-understand plan. You learn SQL frustration free, at the right time in the right order. Enroll today: https://www.essentialsql.com/landing/fsql/enroll-in-fearlesssql/ Important links: Sample PizzaDB: https://github.com/kwenzel1/EssentialSQLSamples/tree/master/PizzaDB Corresponding Article: https://www.essentialsql.com/sql-median/ https://www.essentialsql.com/calculate-the-median-sqlserver/ Source Code: -- Sample Query we'll use select OrderDate, sum(FinalOrderPrice) TotalSales from CustomerOrderSummary group by OrderDate -- Calculate the Median select OrderDate, TotalSales, percentile_cont(.5) within group (order by TotalSales) over() MedianSales from ( select OrderDate, sum(FinalOrderPrice) TotalSales from CustomerOrderSummary group by OrderDate ) d Course: https://www.essentialsql.com/landing/fsql/enroll-in-fearlesssql/