SQL_27_adv

SELECT purchase_order_id,
    ROUND(subtotal,1) AS subtotal,
    ROUND(MIN(subtotal) OVER(ORDER BY purchase_order_id RANGE BETWEEN CURRENT ROW AND 20 FOLLOWING),1) AS min_subtotal
FROM adventure.purchase_order_header;