By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT st.Name,Count(CustomerID) CustomerCount
From Sales.SalesTerritory st
INNER JOIN Sales.Customer c on c.TerritoryID = st.TerritoryID
Group by st.Name
| Name | CustomerCount |
|---|---|
| Northwest | 3520 |
| Northeast | 113 |
| Central | 132 |
| Southwest | 4696 |
| Southeast | 176 |
| Canada | 1791 |
| France | 1884 |
| Germany | 1852 |
| Australia | 3665 |
| United Kingdom | 1991 |