how to use two order by in sql code example

Example 1: multiple order by sql

ORDER BY column1 DESC, column2

Example 2: sql order by two columns

ORDER BY column1 DESC, column2