SELECT c.customerState, COUNT (c.customerState) AS 'Count of Customers' FROM Customer_T c GROUP BY c.customerState HAVING c.customerState IN ('WA', 'OR' ,'CA')
