1. Learn
  2. /
  3. Courses
  4. /
  5. Intermediate SQL

Exercise

Sorting single fields

Now that you understand how ORDER BY works, you'll put it into practice. In this exercise, you'll work on sorting single fields only. This can be helpful to extract quick insights such as the top-grossing or top-scoring film.

The following exercises will help you gain further insights into the film database.

Instructions 1/2

undefined XP
  • 1
    • Select the name of each person in the people table, sorted alphabetically.
  • 2
    • Select the title and duration for every film, from longest duration to shortest.