12.2.5. ORDER BY – Sort Results

Try these first

1. 1.

   What does the ORDER BY clause do in SQL?

   Hint

   Think about how you would arrange items.

2. 2.

   What keyword would you use for ascending order?

   Hint

   It's a simple three-letter word.

3. 3.

   What does the ORDER BY clause do in SQL?

   • True
   • False

   Hint

   Remember, it's all about how the data is presented.

4. 4.

   Which keyword indicates descending order?

   • ORDER
   • ASC
   • DESC

   Hint

   Think about what DESC stands for?

5. 5.

   Create an SQL query that retrieves user data sorted by last login in descending order, ensuring only users who logged in during the last month are included.

   Hint

   Combine WHERE and ORDER BY functions here.

6. 6.

   Write a complex query that retrieves products with a price above a certain threshold, sorts them by category and price, and limits the results to the top 10 entries.

   Hint

   Use both ORDER BY and LIMIT effectively in this challenge.