Datawhale SQL 02

2.1

SELECT product_name,regist_date
FROM product
WHERE regist > '2009-4-28';

2.2

1. 返回购买价格为空的所有记录
2. 返回购买价格不为空的所有记录
3. 返回空列表

2.3

SELECT product_name,sale_price,purchase_price
 FROM product
 WHERE sale_price>=purchase_price+500;

SELECT product_name, sale_price, purchase_price 
 FROM product
 WHERE sale_price-500>=purchase_price;

2.4

SELECT product_name, product_type, (sale_price*0.9-purchase_price) as profit
FROM product
WHERE (sale_price*0.9-purchase_price)>100 AND (product_type='办公用品' OR '厨房用具');

2.5

错误包括：
1、SUM后面使用了中文括号
2、product_name列的类型为str，不能使用SUM函数（值为0）
3、WHERE子句应该放在SELCET后面，GROUP BY
4、注释符后面缺少空格

• SELECT product_id 将得到每一组第一列的值，但无意义。最好替换为聚合键product_type。

2.6

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

2.7

SELECT *
 FROM product
 ORDER BY -regist_date, purchase_price