Que profissionais vivem numa cidade que contenha a substring "Oeste"?
CREATE TABLE professionals (role_code VARCHAR, street VARCHAR, city VARCHAR, state VARCHAR)
SELECT role_code, street, city, state FROM professionals WHERE city LIKE '%West%'