Exercise

Sorting multiple fields

ORDER BY can also be used to sort on multiple fields. It will sort by the first field specified, then sort by the next, and so on. As an example, you may want to sort the people data by age and keep the names in alphabetical order.

Try using ORDER BY to sort multiple columns.

Instructions 1/2

undefined XP
  • 1
    • Select the release_year, duration, and title of films ordered by their release year and duration, in that order.
  • 2
    • Select the certification, release_year, and title from films ordered first by certification (alphabetically) and second by release year, starting with the most recent year.