SELECT Products.SupplierID, Suppliers.CompanyName AS SupplierName, Suppliers.Country, Suppliers.Region,
	[Order Details].ProductID, Products.ProductName,
	Products.CategoryID, Categories.CategoryName, 
	ROUND(SUM([Order Details].UnitPrice * [Order Details].Quantity), 2) AS OrderGross,
	ROUND(SUM([Order Details].UnitPrice * [Order Details].Quantity * [Order Details].Discount), 2) AS OrderDiscount, 
	ROUND(SUM(([Order Details].UnitPrice * [Order Details].Quantity) * (1 - [Order Details].Discount)), 2) AS OrderNet
FROM Products INNER JOIN
	[Order Details] ON Products.ProductID = [Order Details].ProductID INNER JOIN
	Categories ON Products.CategoryID = Categories.CategoryID INNER JOIN
	Orders ON [Order Details].OrderID = Orders.OrderID INNER JOIN
	Suppliers ON Products.SupplierID = Suppliers.SupplierID
GROUP BY [Order Details].OrderID, [Order Details].ProductID, Products.ProductName,
	Products.SupplierID, Suppliers.CompanyName, Suppliers.Country, Suppliers.Region,
	Products.CategoryID, Categories.CategoryName