SQL学习打卡Task2

本笔记为阿里云天池龙珠计划SQL训练营的学习内容，链接为：https://tianchi.aliyun.com/specials/promotion/aicampsql；

练习代码如下：

-- 练习1
SELECT product_name,regist_date
FROM product
WHERE regist_date > '2009-4-28';

-- 练习2
/* ①结果为product中所有purchase_price为NULL的值
②结果为product中所有purchase_price不为NULL的值
③结果为product中所有purchase_name不为NULL的值
*/

-- 练习3
SELECT product_name,sale_price,purchase_price
FROM product
WHERE sale_price - purchase_price > 500;

-- 练习4
SELECT product_name AS name,
product_type AS type,
sale_price * 0.9 - purchase_price AS profit 
FROM product;

/* 练习5
1. product_name 前应该用COUNT
2.WHERE 语句应该写在GROUP BY 前面
3. GROUP BY 后面的字段选择错误，不在SELECT里面
*/

-- 练习6
SELECT product_type,
SUM(sale_price) AS sum,
SUM(purchase_price) AS sum
FROM product
GROUP BY product_type
HAVING SUM(sale_price) > SUM(purchase_price)*1.5;

-- 练习7
select * from product
order by sale_price,regist_date DESC; 

'/c