一个查询的问题

Question

给出表结构
说出需要的结果

Answer 1

Select  a.rq as 合计,a.fdkc,a.ckkc,a.lskc,a.yfk,a.ysk,a.yhck,a.xj,a.jk,a.dk,a.zje
From finance_zje a 
Where datediff(day,rq,'2003-4-21')>=0 and datediff(day,rq,'2003-4-7')<=0
union all 
Select '20031212' as rq,sum(x.fdkc)fdkc,sum(x.ckkc)ckkc,sum(x.lskc)lskc,sum(x.yfk)yfk,sum(x.ysk)ysk,
sum(x.yhck)yhck,sum(x.xj)xj,sum(x.jk)jk,sum(x.dk)dk,sum(x.zje)zje
From 
(Select  a.rq,a.fdkc,a.ckkc,a.lskc,a.yfk,a.ysk,a.yhck,a.xj,a.jk,a.dk,a.zje
From finance_zje a 
Where datediff(day,rq,'2003-4-21')>=0 and datediff(day,rq,'2003-4-7')<=0)x
order by rq desc