SELECT DISTINCT os1.zeme, (
    SELECT COUNT(ob1.oID)
    FROM test.Osoba os2
    JOIN test.Objednavka ob1 ON os2.uID = ob1.uID
    WHERE os2.zeme = os1.zeme
    ) AS pocet_objednavok, (
    SELECT SUM(pl1.kusu)
    FROM test.Osoba os2
    JOIN test.Objednavka ob1 ON os2.uID = ob1.uID
    JOIN test.Polozka pl1 ON pl1.oID = ob1.oID
    JOIN test.Zbozi zb1 ON zb1.zID = pl1.zID
    WHERE os2.zeme = os1.zeme AND zb1.aktualni_cena < pl1.cena
    ) AS vyssi_cena
FROM test.Osoba os1