select CisloZamestnance, ZemePrijemce, sum(Mezisoucet) AS trzba from Objednavky group by CisloZamestnance, ZemePrijemce

union

select '0', ZemePrijemce, sum(Mezisoucet) from Objednavky group by ZemePrijemce

union

select CisloZamestnance,'-',sum(Mezisoucet) AS trzba from Objednavky group by CisloZamestnance

union

select '0','-', sum(Mezisoucet) from Objednavky

order by 1,2;

=======================================================
select Prijmeni, ZemePrijemce, sum(Mezisoucet) AS trzba 
from Objednavky O inner join Zamestnanci Z
on O.CisloZamestnance=Z.CisloZamestnance
group by O.CisloZamestnance,Prijmeni,ZemePrijemce

union

select '-', ZemePrijemce, sum(Mezisoucet) from Objednavky group by ZemePrijemce

union

select Prijmeni,'-',sum(Mezisoucet) from Objednavky O inner join Zamestnanci Z
on O.CisloZamestnance=Z.CisloZamestnance
group by O.CisloZamestnance,Prijmeni

union

select '-','-', sum(Mezisoucet) from Objednavky

order by 1,2;
=====================================================

select Firma AS Dodavatel, NazevKategorie AS Kategorie, sum(VyslednaCena) AS trzba
from Dodavatele D, Vyrobky V,Kategorie K, RozpisObjednavek R
where D.CisloDodavatele=V.CisloDodavatele
and V.CisloKategorie=K.CisloKategorie
and R.CisloVyrobku=V.CisloVyrobku
group by D.CisloDodavatele,K.CisloKategorie

union

select "-", NazevKategorie, sum(VyslednaCena) AS trzba from Vyrobky V,Kategorie K, RozpisObjednavek R
where V.CisloKategorie=K.CisloKategorie
and R.CisloVyrobku=V.CisloVyrobku
group by K.CisloKategorie

union

select Firma, "-", sum(VyslednaCena) AS trzba
from Dodavatele D, Vyrobky V, RozpisObjednavek R where D.CisloDodavatele=V.CisloDodavatele
and R.CisloVyrobku=V.CisloVyrobku
group by D.CisloDodavatele

union

select "-","-",sum(VyslednaCena) 
from RozpisObjednavek 

order by 1,2;