sql order by two status columns 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