order by multiple columns in sql using when 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