This lesson is part of the paid course

Sign in to check whether your enrollment covers this lesson.

Sign inFree lessons
Module 04 · SQL for Data Analysis18 min

ORDER BY, DISTINCT and CASE

Sorting, de-duplicating and building derived columns with CASE WHEN.

By the end of this lesson you can

  • Sort on several keys
  • Bucket values with CASE

Know someone who should take this course?

They will land on the course page with the free lessons open to them.

Lesson feedback

No ratings for this lesson yet.

Sign in to rate this lesson.

WHERE, Operators and NULLCOUNT, SUM, AVG and GROUP BY