Problem Statement
Write a recursive Common Table Expression (CTE) to generate a single-column table containing numbers from 1 to 10. Alias the column as `num`.
Skills Evaluated
WITH RECURSIVEUnion All
Write your SQL query in the editor on the right and click **Run Query**. The system runs your query and compares the result dataset with the official solution. Results must match row-for-row, column-for-column.
Expected Output Format
Executing expected result set...SQL Query WorkspaceSQLite v3.45 (WASM Mode)
QUICK INSERT:
1