第三章 练习题

3.2

SELECT
    product_type,
    sum(sale_price),
    sum(purchase_price)
FROM
    product
GROUP BY
    product_type
HAVING
    sum(sale_price) > 1.5 * sum(purchase_price);

3.3

SELECT
    *
FROM
    product
ORDER BY
    regist_date DESC,
    sale_price ASC;