Analytic functions on the example of Oracle

Analytical functions on the example of Oracle, LAG functions.
After reading this material, you will understand how analytic functions work in Oracle. I will consider only one LAG function, but they have one principle of operation.

Unfortunately, I did not manage to properly post a document from docs.google.com, so you can read the original article here .