1.3. Sorting with ORDER BY

Try these first

1. 1.

   What does ORDER BY price ASC do?

   Hint

   Think about how you would organize prices in a list.

2. 2.

   Write an SQL query to select all products sorted alphabetically by name.

   Hint

   Sort using the product name.

3. 3.

   What does the SQL command ORDER BY do?

   • Sorts data
   • Filters data
   • Joins tables

   Hint

   Consider what we do to organize lists.

4. 4.

   True or False: The ASC keyword sorts data in descending order.

   • True
   • False

   Hint

   Think about what 'ascending' means.

5. 5.

   Write a SQL query that sorts a list of employees first by department alphabetically and then by their hire date in descending order.

   Hint

   Consider the order in which you want to arrange employees in a report.

6. 6.

   Formulate a query that selects all products including their sales amount and sorts them by sales amount descending, but only for the available status.

   Hint

   Combine filtering with your sorting for clarity.