у меня веселеньки получился код.
with
a1(id_MO, id_posel, id_org,
maxR80,minR80,avgR80,maxZ80,minZ80,avgZ80,
maxR92,minR92,avgR92,maxZ92,minZ92,avgZ92,
maxR93,minR93,avgR93,maxZ93,minZ93,avgZ93,
maxR95,minR95,avgR95,maxZ95,minZ95,avgZ95,
maxRdr,minRdr,avgRdr,maxZdr,minZdr,avgZdr,
maxR98,minR98,avgR98,maxZ98,minZ98,avgZ98,
maxRdi,minRdi,avgRdi,maxZdi,minZdi,avgZdi,
maxRg,minRg,avgRg,maxZg,minZg,avgZg,
date)
as (select MO.id, posel.id, org.id,
max(R_A80), min(R_A80),avg(R_A80),max(Z_A80), min(Z_A80),avg(Z_A80),
max(R_AI92), min(R_AI92),avg(R_AI92),max(Z_AI92), min(Z_AI92),avg(Z_AI92),
max(R_AI93), min(R_AI93),avg(R_AI93),max(Z_AI93), min(Z_AI93),avg(Z_AI93),
max(R_AI95), min(R_AI95),avg(R_AI95),max(Z_AI95), min(Z_AI95),avg(Z_AI95),
max(R_Drive), min(R_Drive),avg(R_Drive),max(Z_Drive), min(Z_Drive),avg(Z_Drive),
max(R_AI98), min(R_AI98),avg(R_AI98),max(Z_AI98), min(Z_AI98),avg(Z_AI98),
max(R_Disel), min(R_Disel),avg(R_Disel),max(Z_Disel), min(Z_Disel),avg(Z_Disel),
max(R_Gaz), min(R_Gaz),avg(R_Gaz),max(Z_Gaz), min(Z_Gaz),avg(Z_Gaz),
strftime('%d.%m.%Y',kash.date) as datekash
from kash
left outer join azs on azs.id=kash.id_azs
left outer join org on org.id=azs.id_org
left outer join posel on posel.id=azs.id_posel
left outer join MO on MO.id=azs.id_MO
where datekash=strftime('%d.%m.%Y',{dataot}) and kash.gotov=1
group by MO.id, posel.id, org.id),
a2(id_MO, id_posel,
maxR80,minR80,avgR80,maxZ80,minZ80,avgZ80,
maxR92,minR92,avgR92,maxZ92,minZ92,avgZ92,
maxR93,minR93,avgR93,maxZ93,minZ93,avgZ93,
maxR95,minR95,avgR95,maxZ95,minZ95,avgZ95,
maxRdr,minRdr,avgRdr,maxZdr,minZdr,avgZdr,
maxR98,minR98,avgR98,maxZ98,minZ98,avgZ98,
maxRdi,minRdi,avgRdi,maxZdi,minZdi,avgZdi,
maxRg,minRg,avgRg,maxZg,minZg,avgZg)
as (select id_MO, id_posel,
max(maxR80),min(minR80),avg(avgR80),max(maxZ80),min(minZ80),avg(avgZ80),
max(maxR92),min(minR92),avg(avgR92),max(maxZ92),min(minZ92),avg(avgZ92),
max(maxR93),min(minR93),avg(avgR93),max(maxZ93),min(minZ93),avg(avgZ93),
max(maxR95),min(minR95),avg(avgR95),max(maxZ95),min(minZ95),avg(avgZ95),
max(maxRdr),min(minRdr),avg(avgRdr),max(maxZdr),min(minZdr),avg(avgZdr),
max(maxR98),min(minR98),avg(avgR98),max(maxZ98),min(minZ98),avg(avgZ98),
max(maxRdi),min(minRdi),avg(avgRdi),max(maxZdi),min(minZdi),avg(avgZdi),
max(maxRg),min(minRg),avg(avgRg),max(maxZg),min(minZg),avg(avgZg)
from a1 group by id_MO, id_posel)
select
MO.name,
max(maxR80),min(minR80),avg(avgR80),max(maxZ80),min(minZ80),avg(avgZ80),
max(maxR92),min(minR92),avg(avgR92),max(maxZ92),min(minZ92),avg(avgZ92),
max(maxR93),min(minR93),avg(avgR93),max(maxZ93),min(minZ93),avg(avgZ93),
max(maxR95),min(minR95),avg(avgR95),max(maxZ95),min(minZ95),avg(avgZ95),
max(maxRdr),min(minRdr),avg(avgRdr),max(maxZdr),min(minZdr),avg(avgZdr),
max(maxR98),min(minR98),avg(avgR98),max(maxZ98),min(minZ98),avg(avgZ98),
max(maxRdi),min(minRdi),avg(avgRdi),max(maxZdi),min(minZdi),avg(avgZdi),
max(maxRg),min(minRg),avg(avgRg),max(maxZg),min(minZg),avg(avgZg)
from a2
left outer join MO on MO.id=a2.id_MO
group by MO.id
order by mo.kod
Чучкин Евгений
Нефтепродукты.rar 478.1 kb, 458 downloads since 2016-03-23 
.