text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE professionals (role_code VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR)
  ### Question:
  Which professionals live in a city containing the substring 'West'? List his or her role, street, city and state.
  ### Answer:
  SELECT role_code, street, city, state FROM professionals WHERE city LIKE '%West%'