写完头大

select
sum(dayDatasTab.inquant_smokecoal),
sum(dayDatasTab.inquant_poorcoal),
sum(dayDatasTab.sum_inquant_coals),
sum(dayDatasTab.consumequant_n1_smokecoal),
sum(dayDatasTab.consumequant_n1_poorcoal),
sum(dayDatasTab.sum_consumequant_n1_coals),
sum(dayDatasTab.sum_consumequant_n2_coals),
sum(dayDatasTab.sum_consumequant_pp_smokecoals),
sum(dayDatasTab.sum_consumequant_pp_poorcoals),
sum(dayDatasTab.total_consumequant_n1_coals),
sum(dayDatasTab.kc_smokecoal),
sum(dayDatasTab.kc_poorcoal),
sum(dayDatasTab.kc_sum_coals),
sum(dayDatasTab.givequant_n1_coal),
sum(dayDatasTab.givequant_n2_coal),
sum(dayDatasTab.givequant_sum_coals),
sum(dayDatasTab.consumequant_n1_oil),
sum(dayDatasTab.consumequant_n2_oil),
sum(dayDatasTab.consumequant_sum_oils),
sum(dayDatasTab.kc_quant_oils),
sum(dayDatasTab.givequant_n1_water),
sum(dayDatasTab.givequant_n2_water),
sum(dayDatasTab.givequant_sum_waters),
sum(dayDatasTab.givequant_oldwater),
sum(dayDatasTab.consumequant_n1_ppelectric),
sum(dayDatasTab.consumequant_n2_ppelectric),
sum(dayDatasTab.consumequant_sum_ppelectric),
sum(dayDatasTab.quant_netpower),
sum(dayDatasTab.genquant_n1_electric),
sum(dayDatasTab.genquant_n2_electric),
sum(dayDatasTab.genquant_sum_electrics),
sum(dayDatasTab.gen_electric_pp_rates),
sum(dayDatasTab.total_pp_rates),
sum(dayDatasTab.codovalue_hphottab),
sum(dayDatasTab.givehotunit_hp),
sum(dayDatasTab.inkquant_caco3_carnum),
sum(dayDatasTab.inkquant_caco3_heft),
sum(dayDatasTab.consumequant_n1_caco3),
sum(dayDatasTab.consumequant_n2_caco3),
sum(dayDatasTab.salecarnum_gyp),
sum(dayDatasTab.salecarnum_ash),
sum(dayDatasTab.salecarnum_dregs),
sum(dayDatasTab.level_n1_nh3ho3),
sum(dayDatasTab.level_n2_nh3ho3),
sum(dayDatasTab.kc_ho3nh4)
from(select
dates,
inquant_smokecoal ,
inquant_poorcoal ,
inquant_smokecoal+inquant_poorcoal as sum_inquant_coals,
consumequant_n1_smokecoal ,
consumequant_n1_poorcoal ,
consumequant_n1_smokecoal+consumequant_n1_poorcoal as sum_consumequant_n1_coals,
consumequant_n2_smokecoal ,
consumequant_n2_poorcoal ,
consumequant_n2_smokecoal+consumequant_n2_poorcoal as sum_consumequant_n2_coals,
consumequant_n1_smokecoal+consumequant_n2_smokecoal as sum_consumequant_pp_smokecoals ,
consumequant_n1_poorcoal+consumequant_n2_poorcoal as sum_consumequant_pp_poorcoals ,
consumequant_n1_smokecoal+consumequant_n1_poorcoal+consumequant_n2_smokecoal+consumequant_n2_poorcoal as total_consumequant_n1_coals,
(inquant_smokecoal-(consumequant_n1_smokecoal+consumequant_n2_smokecoal)) as kc_smokecoal,
(inquant_poorcoal-(consumequant_n1_poorcoal+consumequant_n2_poorcoal)) as kc_poorcoal,
(inquant_smokecoal+inquant_poorcoal) - (consumequant_n1_smokecoal+consumequant_n1_poorcoal+consumequant_n2_smokecoal+consumequant_n2_poorcoal) as kc_sum_coals,
givequant_n1_coal,
givequant_n2_coal,
givequant_n1_coal+givequant_n2_coal as givequant_sum_coals,
consumequant_n1_oil ,
consumequant_n2_oil ,
consumequant_n1_oil+consumequant_n2_oil as consumequant_sum_oils ,
consumequant_n1_oil+consumequant_n2_oil as kc_quant_oils,
givequant_n1_water ,
givequant_n2_water ,
givequant_n1_water+givequant_n2_water as givequant_sum_waters,
givequant_oldwater ,
consumequant_n1_ppelectric ,
consumequant_n2_ppelectric ,
consumequant_n1_ppelectric+consumequant_n2_ppelectric as consumequant_sum_ppelectric,
quant_netpower ,
genquant_n1_electric ,
genquant_n2_electric ,
genquant_n1_electric+genquant_n2_electric as genquant_sum_electrics,
((consumequant_n1_ppelectric+consumequant_n2_ppelectric)/(genquant_n1_electric+genquant_n2_electric))*100 as gen_electric_pp_rates,
(((genquant_n1_electric+genquant_n2_electric)-quant_netpower) / (genquant_n1_electric+genquant_n2_electric)) *100 as total_pp_rates,
codovalue_hphottab ,
givehotunit_hp ,
inkquant_caco3_carnum ,
inkquant_caco3_heft ,
consumequant_n1_caco3 ,
consumequant_n2_caco3 ,
salecarnum_gyp ,
salecarnum_ash ,
salecarnum_dregs ,
level_n1_nh3ho3 ,
level_n2_nh3ho3,
(level_n1_nh3ho3+level_n2_nh3ho3)*13.6 as kc_ho3nh4
from report_produceddatasmon
group by (dates))
as dayDatasTab
where dates between (select date_trunc(‘month’,current_date)) and
(select date_trunc(‘month’,current_date) + interval’1 month - 1 day’);