0
SELECT SUM([BTL].dbo.OrderTable.Quantity) AS 'Totalquentity',Count(BTL.dbo.OrderTable.OrderID) as TotalOrder

            FROM [BTL].dbo.OrderTable
            JOIN [BTL].dbo.Products
            ON [BTL].dbo.OrderTable.ProductID=[BTL].dbo.Products.ProductID
            Left JOIN [BTL].dbo.Brand
            ON [BTL].dbo.Products.BrandID=[BTL].dbo.Brand.BrandID  
            WHERE  [BTL].dbo.OrderTable.EmployeeID='1' 
            Group by [BTL].dbo.Brand.BrandName,[BTL].dbo.Brand.BrandID"

            I Want to get avg

Edited by Dani: Formatting fixed

3
Contributors
2
Replies
13
Views
1 Week
Discussion Span
Last Post by pty
0

Replace sum with avg. But average (mean) is meaningless without standard deviation, so you'd better work that out too.

Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.