Generate prime numbers in SQL till 1000

primes.mysql

WITH 
    RECURSIVE numbers(N) AS (
        SELECT 2
        UNION ALL
        SELECT N + 1 FROM numbers
        WHERE N < 1000
    )

SELECT F1.N
FROM numbers F1
JOIN numbers F2 ON (F1.N % F2.N) = 0
GROUP BY F1.N
HAVING COUNT(F2.N) = 1;