In an SQL statement using more than one window function, each window function can have a unique window specification.
For example,
SELECT StoreID, SMonth, ProdID, Sales, AVG(Sales) OVER (PARTITION BY StoreID ORDER BY SMonth ROWS BETWEEN 2 PRECEDING AND CURRENT ROW), RANK() OVER (PARTITION BY StoreID ORDER BY Sales DESC) FROM sales_tbl;