sql 管理数据的问题

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 的方式写出 商品代码，还有商品名称，还有购买数量，还有就是购买的总金额。

在这里请大神指导