Database: dog_kennels
Question: Find the role, street, city and state of the professionals living in a city that contains the substring 'West'.
SQL:
SELECT role_code ,  street ,  city ,  state FROM professionals WHERE city LIKE '%West%'