SELECT Customers.CompanyName, COUNT(Orders.OrderID) AS [Total Orders],
Customers.CustomerID, SUM([Order Details].Quantity * Products.UnitPrice)
AS Total
FROM Customers INNER JOIN
Orders ON Customers.CustomerID = Orders.CustomerID INNER JOIN
[Order Details] ON Orders.OrderID = [Order Details].OrderID INNER JOIN
Products ON [Order Details].ProductID = Products.ProductID
GROUP BY Customers.CompanyName, Customers.CustomerID
HAVING (Customers.CustomerID = @CustomerID)
