utery_variantaA_3

SELECT z.zID, z.nazev
FROM polozka p
JOIN zbozi z ON z.zID = p.zID
GROUP BY z.zID, z.nazev
HAVING
(
    SELECT COUNT(*)
    FROM polozka p2
    JOIN zbozi z2 ON z2.zID = p2.zID AND z.zID = z2.zID
    WHERE p2.cena < z2.aktualni_cena
) * 4
>
(
    SELECT COUNT(*)
    FROM polozka p2
    JOIN zbozi z2 ON z2.zID = p2.zID AND z.zID = z2.zID
)