Lesson 17 of 20

Structuring an analysis with CTE and CASE

Break a complex query into named steps and translate a business rule with CASE.

23 minSQL Essentials

By the end of this lesson

  • Create a CTE with WITH
  • Transform a rule into categories with CASE
  • Separate intermediate calculation and final result

SQL Essentials

Continue with the right access

“Structuring an analysis with CTE and CASE” is included from SQL Essentials.

30 free days of SQL Pro on registration, subject to the 33 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.