Untitled

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