sql server order multiple columns code example

Example: sql order by two columns

ORDER BY column1 DESC, column2