how to use order by with where clause in sql code example

Example: order by in sql

ORDER BY: is for sorting result
either in descending or ascending order.