天池sql训练营task2

-- 1
select product_name,regist_date
	from product
	where regist_date > '2009-4-28';

-- 2.1 购入价格为空值的product表所有内容
-- 2.2 购入价格不为空值的product表所有内容
-- 2.3 产品名称大于空值的product表所有内容

-- 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;

-- 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 product_type = '厨房用具');

-- 5
-- 错误1在于product_name是字段不可以sum；错误2在于语句顺序应该是先where后group by；错误3在于group by的字段product_type不在select的字段中

-- 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
	order by sum desc;

-- 7
select *
	from product
	order by regist_date desc, sale_price;