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;
网友评论