Database: dog_kennels
Question: Which owners live in the state whose name contains the substring 'North'? List his first name, last name and email.
SQL:
SELECT first_name ,  last_name ,  email_address FROM Owners WHERE state LIKE '%North%'