Prime numbers

WITH RECURSIVE cte1 AS (
  SELECT
    2 AS val
  UNION
  ALL
  SELECT
    val + 1 AS val
  FROM
    cte1
  WHERE
    cte1.val < 100
),
cte2 AS (
  SELECT
    2 AS val
  UNION
  ALL
  SELECT
    val + 1 AS val
  FROM
    cte2
  WHERE
    cte2.val < 100
)
SELECT
  val AS prime
FROM
  cte1
WHERE
  NOT EXISTS (
    SELECT
      val
    FROM
      cte2
    WHERE
      val < cte1.val
      AND cte1.val % val = 0
  )