Which territory has the most customers as of 9/12/2014?
ModifiedDate between'2014-09-12 00:00:00' and '2014-09-12 23:59:59';
SELECT TerritoryID FROM Customer WHERE ModifiedDate < '2014-12-09' GROUP BY TerritoryID ORDER BY COUNT(TerritoryID) DESC LIMIT 1