Window Function (copy)

SELECT product_id, product_name, model_year, list_price FROM products

SELECT order_id, order_date FROM sales.orders 

SELECT order_id, product_id, discount FROM sales.order_items

SELECT
    model_year,
    AVG(list_price) avg_price
FROM products
GROUP BY model_year

SELECT
   model_year,
   product_name,
   list_price,
   AVG(list_price) OVER 
     (PARTITION BY model_year) avg_price
FROM products
ORDER BY product_name

/* Rank price from LOW->HIGH  */
SELECT 
product_name, 
list_price,
RANK() OVER (ORDER BY list_price ASC) rank
FROM products

   SELECT
    year(order_date) year,
    COUNT(DISTINCT order_id) num_orders
    FROM sales.orders
    GROUP BY year(order_date)

/* Rank price from HIGH->LOW  */
SELECT 
product_name, 
list_price,
RANK() OVER (ORDER BY list_price DESC) rank
FROM products