using aggregate function with order by

SQL ORDER BY keyword is used to sort the result set in ascending or descending order.