Web Listing 3: Set Operation Between TOP Queries
WITH C1997 AS
(
  SELECT TOP (5) ShipCountry, ShipRegion, ShipCity
  FROM dbo.Orders
  WHERE OrderDate >= '19970101' AND OrderDate < '19980101'
  GROUP BY ShipCountry, ShipRegion, ShipCity
  ORDER BY COUNT(*) DESC
),
C1996 AS
(
  SELECT TOP (5) ShipCountry, ShipRegion, ShipCity
  FROM dbo.Orders
  WHERE OrderDate >= '19960101' AND OrderDate < '19970101'
  GROUP BY ShipCountry, ShipRegion, ShipCity
  ORDER BY COUNT(*) DESC
)
SELECT * FROM C1997
EXCEPT
SELECT * FROM C1996;