Correct sorting of report in sql query
I want to sort the numbered numbers in the sql query I wrote. but when I want it to be sorted as 1,2,3.., it is sorted like 1,10,11. I'm having trouble with two-digit numbers.
I tried to take and sort the 2 digits with the SUBSTR function, but it didn't work. (ORDER BY SUBSTR (question_text, 1, 2) ASC)I would be very grateful if you could share what is the way I can solve this.