
O resultado correto da consulta:
SELECT Z FROM R
WHERE Y IN ( SELECT Y FROM S)
GROUP BY Z
HAVING COUNT(*) =
(SELECT COUNT(*) FROM S);

O resultado correto da consulta:
SELECT Z FROM R
WHERE Y IN ( SELECT Y FROM S)
GROUP BY Z
HAVING COUNT(*) =
(SELECT COUNT(*) FROM S);