Actualy it should be:

SELECT

customerID, count(city) as 'Count'

INTO CustomerCities

FROM Customers

GROUP BY CustomerID