Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT TOP (3) dbo.Products.ProductName, SUM(dbo.[ORDER Details].Quantity * dbo.[ORDER Details].UnitPrice) AS TotalPrice, dbo.Suppliers.CompanyName
- FROM dbo.Products INNER JOIN
- dbo.[ORDER Details] ON dbo.Products.ProductID = dbo.[ORDER Details].ProductID INNER JOIN
- dbo.Suppliers ON dbo.Products.SupplierID = dbo.Suppliers.SupplierID
- GROUP BY dbo.Products.ProductName, dbo.Suppliers.CompanyName
- ORDER BY TotalPrice
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement