Which professionals live in a city containing the substring 'West'? List his or her role, street, city and state.
CREATE TABLE professionals (role_code VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR)
SELECT role_code, street, city, state FROM professionals WHERE city LIKE '%West%'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: 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. [/INST] SELECT role_code, street, city, state FROM professionals WHERE city LIKE '%West%' </s>