Which owners live in the state whose name contains the substring 'North'? List his first name, last name and email.
create table owners (first_name varchar, last_name varchar, email_address varchar, state varchar, PRIMARY KEY (first_name))
select first_name, last_name, email_address from owners where state like '%north%'