order by in mysql for multiple columns code example

Example: mysql multiple order by

ORDER BY col1, col2 DESC, col3;