For examples of different types of calculation, refer to:
"Simple calculation examples"
"Oracle8i analytic function examples"
"Oracle9i analytic function examples"
"Examples of using row-based and time-based intervals"