一、练习:
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, p