utery_variantaB_3

SELECT z.zID, z.nazev
FROM objednavka ob
JOIN polozka p ON p.oID = ob.oID
JOIN zbozi z ON z.zID = p.zID
GROUP BY z.zID, z.nazev
HAVING
COUNT(CASE WHEN kusu > 2 THEN 1 ELSE NULL END) * 2
>
COUNT(*)