SELECT first_name ,  last_name ,  email_address FROM Owners WHERE state LIKE '%North%'
Which owners live in the state whose name contains the substring 'North'? List his first name, last name and email.
SELECT first_name , last_name , email_address FROM Owners WHERE state LIKE ' % North % '
select first_name , last_name , email_address from owners where state like value
Which owners live in the state whose name contains the substring 'North ' ? List his first name , last name and email .