天池龙珠计划SQL训练营--Task02：SQL基础查询与排序

/*练习题-第一部分

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

/*练习题2*/
SELECT * 
  FROM product 
  WHERE  not purchase_price = NULL ; 

--执行没有结果，将‘=’ 改为‘is’-->purchase_price is NULL；

练习3

SELECT `product_name` ,`sale_price` ,`purchase_price` 

FROM `product` 

WHERE `sale_price`-`purchase_price` >=500;

练习题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*/
SELECT product_type,count(*)
  FROM product 
   WHERE regist_date > '2009-09-01'
 GROUP BY product_type ;
 

/*练习6*/
SELECT `product_type` , sum(`sale_price` ) as sale_sum,sum(`purchase_price` ) as pur_sum
  FROM product 
GROUP BY `product_type` 
HAVING sale_sum/pur_sum >1.5; 

/*练习7*/
SELECT * FROM product
ORDER BY sale_price,regist_date DESC;