Demonstration of the ORDER BY clause should include the following sorting or querying strategies performed on a given set of data:

Note: ORDER BY is always the last clause, because it rearranges the final ResultSet after all selection criteria is executed.