Example: Using RANK and AVG - Teradata Vantage

Consider the result of the following SELECT statement using the following ordered analytical functions, RANK and AVG.

   SELECT item, smonth, sales, 
   RANK() OVER (PARTITION BY item ORDER BY sales DESC), 
   AVG(sales) OVER (PARTITION BY item 
                    ORDER BY smonth 
                    ROWS 3 PRECEDING)
   FROM sales_tbl
   ORDER BY item, smonth;

The results table may look like the following.