Practice Sorting With Order By (1.3) - SQL for Business Analysts

Practise this section

9 questions

Flashcard drill
3 cards from this section. Quick, good the night before a test.
Exercise
6 questions · about 4 min · pass mark 70%. Hints available.
Sign up to start the exercise
Quiz
3 questions · about 2 min · pass mark 70%. Hints available.
Sign up to start the quiz

6 sample questions

Question 1.
What does ORDER BY price ASC do?
Show hintHide hint
Think about how you would organize prices in a list.
Question 2.
Write an SQL query to select all products sorted alphabetically by name.
Show hintHide hint
Sort using the product name.
3Question 3.
What does the SQL command ORDER BY do?
- Sorts data
- Filters data
- Joins tables
Show hintHide hint
Consider what we do to organize lists.
4Question 4.
True or False: The ASC keyword sorts data in descending order.
- True
- False
Show hintHide hint
Think about what 'ascending' means.
Question 5.
Write a SQL query that sorts a list of employees first by department alphabetically and then by their hire date in descending order.
Show hintHide hint
Consider the order in which you want to arrange employees in a report.
Question 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.
Show hintHide hint
Combine filtering with your sorting for clarity.

5 more questions in this section. Enroll free to practise them all.