SCHEMA:
CREATE TABLE professionals (role_code VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR)
USER:
Which professionals live in a city containing the substring 'West'? List his or her role, street, city and state.

QUERY:
SELECT role_code, street, city, state FROM professionals WHERE city LIKE '%West%'