SQL - ayuda consulta northwind

esta es la base de datos northwind

SELECT dbo.Categories.CategoryName, dbo.Products.ProductName, dbo.[Order Details].UnitPrice, dbo.[Order Details].Quantity, dbo.Customers.CompanyName,
dbo.Orders.OrderDate, dbo.Orders.OrderID
FROM dbo.Products INNER JOIN
dbo.[Order Details] ON dbo.Products.ProductID = dbo.[Order Details].ProductID INNER JOIN
dbo.Orders ON dbo.[Order Details].OrderID = dbo.Orders.OrderID INNER JOIN
dbo.Categories ON dbo.Products.CategoryID = dbo.Categories.CategoryID INNER JOIN
dbo.Customers ON dbo.Orders.CustomerID = dbo.Customers.CustomerID

MOSTRAR el pedido DE MAYOR MONTO POR AÑOS PARA EL MEJOR CLIENTE

ejemplo:

================================================================
================================================================

AÑO DE VENTA MEJORCLIENTE FACTURA MONTO
============ ============ ====== =======
2003 1 00025 252536.00
2004 2 00125 592896.00
2005 1 00925 589542.00
2006 3 03255 269345.00
2007 3 15825 999654.50

quien puede ayudarme

SELECT * FROM (SELECT TOP 1 Anio, Temp.Total, CustomerID from
(SELECT TOP (100) PERCENT dbo.Orders.OrderID, DATEPART(YEAR, dbo.Orders.OrderDate) AS Anio, SUM(dbo.[Order Details].UnitPrice * dbo.[Order Details].Quantity) AS Total,
dbo.Customers.CustomerID
FROM dbo.Orders INNER JOIN
dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN
dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID INNER JOIN
dbo.Customers ON dbo.Orders.CustomerID = dbo.Customers.CustomerID
GROUP BY DATEPART(YEAR, dbo.Orders.OrderDate), dbo.Orders.OrderID, dbo.Customers.CustomerID
ORDER BY Anio DESC, Total DESC) AS Temp
WHERE Anio = 1998
ORDER BY Anio DESC, Total DESC) AS Anio1
UNION
SELECT * FROM (SELECT TOP 1 Anio, Temp.Total, CustomerID from
(SELECT TOP (100) PERCENT dbo.Orders.OrderID, DATEPART(YEAR, dbo.Orders.OrderDate) AS Anio, SUM(dbo.[Order Details].UnitPrice * dbo.[Order Details].Quantity) AS Total,
dbo.Customers.CustomerID
FROM dbo.Orders INNER JOIN
dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN
dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID INNER JOIN
dbo.Customers ON dbo.Orders.CustomerID = dbo.Customers.CustomerID
GROUP BY DATEPART(YEAR, dbo.Orders.OrderDate), dbo.Orders.OrderID, dbo.Customers.CustomerID
ORDER BY Anio DESC, Total DESC) AS Temp
WHERE Anio = 1997
ORDER BY Anio DESC, Total DESC) AS Anio2
UNION
SELECT * FROM (SELECT TOP 1 Anio, Temp.Total, CustomerID from
(SELECT TOP (100) PERCENT dbo.Orders.OrderID, DATEPART(YEAR, dbo.Orders.OrderDate) AS Anio, SUM(dbo.[Order Details].UnitPrice * dbo.[Order Details].Quantity) AS Total,
dbo.Customers.CustomerID
FROM dbo.Orders INNER JOIN
dbo.[Order Details] ON dbo.Orders.OrderID = dbo.[Order Details].OrderID INNER JOIN
dbo.Products ON dbo.[Order Details].ProductID = dbo.Products.ProductID INNER JOIN
dbo.Customers ON dbo.Orders.CustomerID = dbo.Customers.CustomerID
GROUP BY DATEPART(YEAR, dbo.Orders.OrderDate), dbo.Orders.OrderID, dbo.Customers.CustomerID
ORDER BY Anio DESC, Total DESC) AS Temp
WHERE Anio = 1996
ORDER BY Anio DESC, Total DESC) AS Anio3

como Obtener el número de productos, por categoría. Mostrando el nombre de la categoría, el nombre del producto, y el total de productos por categoría, solamente de las categorías 3, 5 y 8. Ordenar por el nombre de la categoría , usando base de datos NORTHWIND , ayuda porfa...