SELECT po.pID,
(
	SELECT COUNT(ob.oID) as pocet_80tis
	FROM test.Zamestnanec za
	LEFT JOIN test.Objednavka ob ON ob.zaID = za.zaID
	WHERE za.pID = po.pID
	GROUP BY ob.oID
	HAVING
		(
			SELECT SUM(pol.cena * pol.kusu)
			FROM test.Polozka pol
			WHERE pol.oID = ob.oID
		) > 80000
)
FROM test.Pobocka po