T2.NUMBER
FROM
(
SELECT
NUMBER,
COUNT(ID) OVER(PARTITION BY NUMBER) AS CN
FROM
GRADE
)T2
WHERE T2.CN >= 3
GROUP BY T2.NUMBER
T2.NUMBER
FROM
(
SELECT
NUMBER,
COUNT(ID) OVER(PARTITION BY NUMBER) AS CN
FROM
GRADE
)T2
WHERE T2.CN >= 3
GROUP BY T2.NUMBER