本笔记为阿里云天池龙珠计划SQL训练营的学习内容,链接为:https://tianchi.aliyun.com/specials/promotion/aicampsql;
题5
SELECT product_id, SUM(product_name)
--本SELECT语句中存在错误。
FROM product
GROUP BY product_id -- group by列有误
WHERE regist_date > '2009-09-01';
题6
select product_type,sum(sale_price),sum(purchase_price)
from product
group by product_type
having sum(sale_price)>sum(purchase_price)*1.5
题7
select * from product order by register_date;