SQL Print 1 to 9

Write a SQL query to print numbers from 1 to 9.

Use the numbers table and return only values in the requested range. Values outside the range and rows with a NULL number must be ignored.

Output

1. One column named number
2. Values from 1 through 9, one per row
3. Results ordered in ascending numeric order