---

CREATE VIEW OrdersCost AS
SELECT 
    dbo.Clients.ClientName, 
    dbo.Products.ProductName,
    dbo.Orders.OrderDate, 
    dbo.Orders.DeliveryDate,
    dbo.Products.Price * dbo.Orders.Quantity AS COST
FROM dbo.Clients 
INNER JOIN dbo.Locations 
    ON dbo.Clients.Location = dbo.Locations.LocationID
INNER JOIN dbo.Orders 
    ON dbo.Clients.ClientID = dbo.Orders.Client
INNER JOIN dbo.Products 
    ON dbo.Orders.Product = dbo.Products.ProductID
ORDER BY 
    dbo.Clients.ClientName, 
    dbo.Products.ProductName DESC;