Which professionals live in a city containing the substring 'West'? List his or her role, street, city and state.
SELECT role_code ,  street ,  city ,  state FROM professionals WHERE city LIKE '%West%'
SELECT role_code ,  street ,  city ,  state FROM professionals WHERE city LIKE '%West%'
[{'role_code': 'Employee', 'street': '6915 Oberbrunner Point Suite 491\nGleasonville, LA ', 'city': 'West Heidi', 'state': 'Indiana'}]