Oracle的查詢

如下一張表
SQL> desc pos_dispatchs
Name                   Type         Nullable Default Comments                                    
---------------------- ------------ -------- ------- ------------------------------------------- 
POSSHOP_NO             VARCHAR2(10)                  門市代號                                    
POSMAC_NO              VARCHAR2(4)                   POS機代號                                   
POSDISPATCH_NO         VARCHAR2(15)                  門市銷售單號                                
POSDISPATCH_ITEM       VARCHAR2(4)                   門市銷售項次                                
TRADE_TYPE             VARCHAR2(1)                   交易類別: 1/2 售出/退貨                     
GOOD_MK                VARCHAR2(1)                   良品注記 Y/N 良品/不良品                    
UNION_MK               VARCHAR2(1)                   商品類別 1/2 普通商品/贈品                  
PRODUCTS_ID            VARCHAR2(15)                  商品主編碼                                  
PRODUCTS_ATTRIBUTES_ID VARCHAR2(20)                  商品子編碼                                  
PRODUCTS_PRICE         NUMBER(10,2) Y                單價                                        
DIS_PERCENT            NUMBER(12,4) Y                折扣                                        
DONE_PRICE             NUMBER(10,2) Y                成交價                                      
SALE_QTY               NUMBER(10,2) Y                數量                                        
DONE_MONEY             NUMBER(10,2) Y                成交金額                                    
REFUNC_REASON          VARCHAR2(20) Y                退貨原因                                    
OK_MK                  VARCHAR2(1)                   有效注記                                    
UPLOAD_MK              VARCHAR2(1)  Y                上傳注記門市使用 Y/N/0 已上傳/未上傳/上傳中 
WORK_DATE              VARCHAR2(8)  Y                門市銷售發貨日期                            
TSALE_QTY              NUMBER(10,2) Y                已退貨數                                    
POSSHOP_NO1            VARCHAR2(10) Y                原購買門市                                  
POSMAC_NO1             VARCHAR2(4)  Y                原購買機號                                  
POSDISPATCH_NO1        VARCHAR2(15) Y                原購買單號                                  
POSDISPATCH_ITEM1      VARCHAR2(4)  Y                原購買項次 我要怎么樣才能夠得到﹐我怎么樣統計一斷時間內﹐銷售數量和銷售金額