CREATE TABLE professionals (role_code VARCHAR(255), street VARCHAR(255), city VARCHAR(255), state VARCHAR(255))
Which professionals live in a city containing the substring 'West'? List his or her role, street, city and state.
    
SQL: SELECT role_code, street, city, state FROM professionals WHERE city LIKE '%West%'