how to sort in sql order by with two columns code example

Example: sql order by two columns

ORDER BY column1 DESC, column2