Aggregate functions are often used to derive descriptive statistics. Aggregate functions are often used in databases, spreadsheets, and statistical software packages now common in the workplace.

SQL window functions provide extremely powerful and useful features that let you work with observations more easily. Different types explained here.

I realized how much easier my life would be if SQL had a mode() aggregate function. (I'm using it in the mathematical sense). I'm guessing that either I use SQL in a wierd way or there is a good ...