1 and order by are the sorting keywords of SQL, followed by the field name, and the data can be sorted according to the value of this field.

2. Your question is whether the sorted fields must be integers. The answer is no, the field type is not necessarily an integer, but a character type, a floating point type and a Boolean type can be used.

I hope it will help you, and I wish you something.