Que proprietários vivem no estado cujo nome contém a substring "North"?
CREATE TABLE Owners (first_name VARCHAR, last_name VARCHAR, email_address VARCHAR, state VARCHAR)
SELECT first_name, last_name, email_address FROM Owners WHERE state LIKE '%North%'