How to use MySQL ORDER BY for analytic functions? In MySQL they are mostly called window functions. The goal is to perform various calculations on groups of data in a single pass. And their results are very useful for data analysis. Therefore, it turns out that window functions are analytic functions - https://www.bollyinside.com/news/technology/mysql-order-by-in-analytical-functions-the-easy-guide-for-starters
