drop table product;
CREATE TABLE PRODUCT(
product_id varchar(6)
,product_name varchar(12)
,in_price integer
,out_price integer
,start_day timestamp
,primary key (product_id,start_day)
);
COMMENT ON TABLE product IS '商品';
COMMENT ON COLUMN product.product_id IS '商品コード';
COMMENT ON COLUMN product.product_name IS '商品名';
COMMENT ON COLUMN product.in_price IS '購入価格';
COMMENT ON COLUMN product.out_price IS '販売価格';
COMMENT ON COLUMN product.start_day IS '販売日' ;
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10001','小米手机','2100',3666,to_date('20190101','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10001','小米手机','2000',3666,to_date('20190201','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10001','小米手机','1988',3666,to_date('20190401','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10002','美的','6100',8666,to_date('20190301','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10002','美的','6300',8666,to_date('20190315','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10002','美的','5900',8666,to_date('20190401','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10003','洗衣机','1980',3666,to_date('20190423','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10003','洗衣机','1790',3666,to_date('20190503','yyyymmdd'));
INSERT INTO PRODUCT(product_id,product_name ,in_price ,out_price,start_day)
VALUES('10003','洗衣机','2000',3666,to_date('20190623','yyyymmdd'));
如何用 select 的方式写出 商品代码,还有商品名称,还有购买数量,还有就是购买的总金额。
在这里请大神指导