SQL编程学习02

一、练习：

2.1

select product_name, regist_date
from product
where regist_date > '20090428';

2.3

-- 方式一：
select product_name, sale_price, purchase_price
from product
where product_type = '衣服' 
or	  sale_price > 5000
;

-- 方式二：
select product_name, sale_price, purchase_price
from product
where product_type = '衣服' 
or (regist_date < '20090220' and purchase_price > 3000);

2.4

select product_name,