第八章 练习题

8.2

SELECT
    product_type,
    regist_date,
    sum(sale_price) over (

        ORDER BY
            colaesce (
                regist_date,
                cast('1996-01-01' AS date)
            )
    ) AS sum_price
FROM
    product
ORDER BY
    regist_date;