Chapter 4 Exercise 22

22. By count of state, where are most of the customers located?

SELECT City.State, Count(Customer.CustomerID) AS CountOfCustomerID
FROM City INNER JOIN Customer ON City.CityID = Customer.CityID
GROUP BY City.State
ORDER BY Count(Customer.CustomerID) DESC;