You can try the below code:
ORDER BY column1 DESC, column2
This will be sorting everything by column1 (in the descending order) first, and then by column2 (in the ascending order, which will be the default) whenever it is seen that the column1 fields for two or more number rows are equal.
Become a SQL expert with this complete SQL Training Course!