SQL学习TASK02

课后习题
2.1
SELECT product_name, regist_date
FROM product
WHERE regist_date>‘2009-4-28’;

2.2

（1）
执行不出来，因为正确语法是is null

SELECT *
FROM product
WHERE purchase_price IS NULL ;

（2）
SELECT *
FROM product
WHERE purchase_price IS NOT NULL ;

2.3

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

2.4
SELECT product_name,product_type,sale_price9 AS profit
FROM product
WHERE (sale_price0.9 -purchase_price) >100;

2.5
执行顺序：

SELECT product_id, SUM(product_name)
FROM product
WHERE regist_date >‘2009-09-01’
GROUP BY product_type;

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

![2.7
SELECT *
FROM product
ORDER BY regist_date IS NOT NULL,-regist_date,sale_price;

思维导图