SELECT
sum(shipper_line.all_amt) 总发货金额 ,
(select sum(user_4) from shipper where datediff(week,trans_date+6,getdate())=0 ) 总发货件数,
dateformat(getdate(),'YYYY,MM DD') 截止日,
DATEFORMAT(dateadd(dd,-6,getdate()),'YYYY,MM DD') 启始日
FROM "DBA"."shipper" ,shipper_line
where shipper.trans_no=shipper_line.trans_no and datediff(week,trans_date+6,getdate())=0