S&P Global interview question

Analytical functions in oracle.