Task: Text to Code
Input (English): Which professionals live in a city containing the substring 'West'? List his or her role, street, city and state.
Output (English): SELECT role_code ,  street ,  city ,  state FROM professionals WHERE city LIKE '%West%'