SELECT c.customerName, c.customerCity , c.customerState FROM Customer_T c WHERE c.customerState IN ('WA', 'OR' ,'CA') ORDER BY c.customerName, c.customerState
