CREATE VIEW [Sales by Customer] (Company, Address, Sales)
AS
SELECT CompanyName, Address + ', ' + City + ', ' + Country, Sum (
CONVERT ( money, ( OD.UnitPrice*Quantity* ( 1-Discount ) /100 ) ) *100 )
FROM Customers C
INNER JOIN Orders O ON C.CustomerID = O.CustomerID
INNER JOIN [Order Details] OD ON O.OrderID = OD.OrderID
GROUP BY CompanyName, Address, City, Country