i4DM Interview Question

Write sql code to get a count of customers by city using a window (or aggregate) function ordered by CustomerCount. Assume two tables Customer and CustomerAddress and a customer may have multiple addresses in multiple cities. Primary Key is CustomerID.