1.3 - Sorting with ORDER BY
Enroll to start learning
You’ve not yet enrolled in this course. Please enroll for free to listen to audio lessons, classroom podcasts and take practice test.
Practice Questions
Test your understanding with targeted questions
What does ORDER BY price ASC do?
💡 Hint: Think about how you would organize prices in a list.
Write an SQL query to select all products sorted alphabetically by name.
💡 Hint: Sort using the product name.
4 more questions available
Interactive Quizzes
Quick quizzes to reinforce your learning
What does the SQL command ORDER BY do?
💡 Hint: Consider what we do to organize lists.
True or False: The ASC keyword sorts data in descending order.
💡 Hint: Think about what 'ascending' means.
1 more question available
Challenge Problems
Push your limits with advanced challenges
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.
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.
Get performance evaluation
Reference links
Supplementary resources to enhance your learning experience.