• And why not using this sentence:

    SELECT C.CustomerID, C.CompanyName,

    COUNT(O.OrderID) AS TotalOrders

    FROM Customers C LEFT OUTER JOIN Orders O ON

    C.CustomerID = O.CustomerID AND (YEAR(O.OrderDate) = 1996 OR O.OrderDate IS NULL)

    GROUP BY C.CustomerID, C.CompanyName