Northwind Database question on Orders Table
asked
Hi, Can anyone please tell me how to get the Number of Orders per territory from the Northwind database?? Regards, Sathya
You can modify below query:
select b.[TerritoryID],sum(a.[OrderQty]) as 'Total Qty' from [Sales].[SalesOrderHeader] B left join [Sales].[SalesOrderDetail] A
on a. [SalesOrderID]=b.[SalesOrderID]
group by B.[TerritoryID] order by b.[TerritoryID]
--------------------------------------------------------------------------------------------------------------------------
SalesOrderHeader-Contains Territory Information and SalesOrderDetail- Contains order qty.
20 People are following this question.
