Task: Text to Code
Input (English): Which owners live in the state whose name contains the substring 'North'? List his first name, last name and email.
Output (English): SELECT first_name ,  last_name ,  email_address FROM Owners WHERE state LIKE '%North%'