SELECT * FROM
(SELECT count(*) hotove from
(select soucet,cena_celkem, round(soucet) zao from
(SELECT sum(platba) soucet ,id_prodeje
from
(SELECT pocet_kusu*cena platba, id_prodeje 
from polozky_prodeje 
join produkty using (id_produkty) 
join nabidky using(id_produkty)
join prodeje using(id_prodeje) 
join oddeleni on (oddeleni.id_pobocky=prodeje.id_pobocky 
and nabidky.id_oddeleni=oddeleni.id_oddeleni)
where cas_prodeje between platnost_od and platnost_do) 
group by id_prodeje) natural join prodeje)
where soucet<>cena_celkem) ,
(SELECT count(*) kartou from
(select soucet,cena_celkem, round(soucet) zao from
(SELECT sum(platba) soucet ,id_prodeje
from
(SELECT pocet_kusu*cena platba, id_prodeje 
from polozky_prodeje 
join produkty using (id_produkty) 
join nabidky using(id_produkty)
join prodeje using(id_prodeje) 
join oddeleni on (oddeleni.id_pobocky=prodeje.id_pobocky 
and nabidky.id_oddeleni=oddeleni.id_oddeleni)
where cas_prodeje between platnost_od and platnost_do) 
group by id_prodeje) natural join prodeje)
where soucet=cena_celkem and zao<>soucet),
(SELECT count(*) nevim from
(select soucet,cena_celkem, round(soucet) zao from
(SELECT sum(platba) soucet ,id_prodeje
from
(SELECT pocet_kusu*cena platba, id_prodeje 
from polozky_prodeje 
join produkty using (id_produkty) 
join nabidky using(id_produkty)
join prodeje using(id_prodeje) 
join oddeleni on (oddeleni.id_pobocky=prodeje.id_pobocky 
and nabidky.id_oddeleni=oddeleni.id_oddeleni)
where cas_prodeje between platnost_od and platnost_do) 
group by id_prodeje) natural join prodeje)
where soucet=cena_celkem and zao=soucet)