select k.ime, count(pk.id_parce) as kupeni_proizvodi_po_kompanija
from kompanija as k
left join parce_e_od_kompanija pk on pk.ime = k.ime
left join parce p on p.id_parce = pk.id_parce
left join parce_e_del_od_naracki pedon on pedon.id_parce = p.id_parce 
left join naracki n on n.id_naracka = pedon.id_naracka 

group by k.ime
order by k desc