Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.40K
|
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 
|