Untitled

SELECT c.customerState, COUNT (c.customerState) AS 'Count of Customers'
FROM Customer_T c
GROUP BY c.customerState 
HAVING COUNT(c.customerID) > 1