SQL Essentials · CTE · CASE

Segment customers with a CTE

Calculate the total per customer, then transform this result into a business segment.

SQL Essentials

Unlock this exercise and continue the path.

Segment customers with a CTE is part of the complete programme: 20 lessons, 44 verifiable exercises and 2 published guided projects.

  • Complete content with explained examples
  • SQL simulator and expected result
  • Detailed answer, common mistakes and challenge
View SQL EssentialsI already have access
Six-month access, one-time payment and no automatic renewal.
Segment customers with a CTE — SQL exercise — SQL.tn