What is ORDER BY clause in SQL?

Question

ORDER BY clause: This clause is used to define the order of the query output either in ascending (ASC) or in descending (DESC). Ascending (ASC) is set as the default one but descending (DESC) is set explicitly.

Syntax:

SELECT column_name(s)  FROM table_name  WHERE condition  ORDER BY column_name ASC|DESC;