how to order by ascending in sql code example

Example 1: sql order by

Used to sort the result data in ascending (default) or descending order
through the use of ASC or DESC keywords.
Example: Returns countries in alphabetical order.
SELECT * FROM countries
ORDER BY name;

Example 2: order by in sql

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