低压线损月报表

select
b.名称,
c.线路编号 as 单位,
sum(isnull(a.供电量,0))as 供电,
sum(isnull(a.售电量,0))as 用电,
sum(isnull(a.供电量,0))-sum(isnull(a.售电量,0))as 损电,
(sum(isnull(a.供电量,0))-sum(isnull(a.售电量,0))*100/(sum(a.供电量)+0.000001))as 损率,
sum(isnull(a.结算金额,0))as 电费,
(sum(isnull(a.结算金额,0))/(sum(a.售电量)+0.000001))as 平均电价,
sum(a.累计供电量)as 累计供电,
sum(a.累计售电量)as 累计用电,
(sum(a.累计供电量)-sum(a.累计售电量))as 累计损电,
((sum(a.累计供电量)-sum(a.累计售电量))*100/(sum(a.累计供电量)+0.0000001))as 累计损率,
累计金额=(select sum(结算金额) from df_hztq where 所编号=a.所编号 and 年月 between '200901' and '200904')
from df_hztq a,bs_gdsda b,bs_10kvda c
where a.所编号=b.所编号 and  a.年月='200904'
group by b.名称,a.所编号,c.线路编号
order by b.名称,a.所编号,c.线路编号