order by 3 fields mysql code example

Example: mysql multiple order by

ORDER BY col1, col2 DESC, col3;