Introduction
Custom classifications of business objects
Custom grouping of business objects
Custom counting of business objects
Instruction
Very well done! Let's do one more exercise to practice this concept.
Exercise
Washington (WA) is Northwind's primary region. How many orders have been processed by employees in the WA region, and how many by employees in other regions? Show two columns with their respective counts: OrdersWAEmployees and OrdersNotWAEmployees.
Stuck? Here's a hint!
Use the following COUNT() expression:
COUNT(CASE WHEN Region = N'WA' THEN OrderID END)
