-- List the last name and first name of every owner who lives in Seattle.
CREATE TABLE OWNER (
    OWNER_NUM CHAR (5) PRIMARY KEY,
    LAST_NAME VARCHAR (10),
    FIRST_NAME VARCHAR (10),
    ADDRESS CHAR (25),
    CITY VARCHAR (10),
    STATE CHAR(2),
    POSTAL INT(5)
);
-- insert some values
INSERT INTO OWNER 
    VALUES 
    ('MO100','Moore','Elle-May','8006 W. Newport Ave.','Reno','NV', 89508),
    ('PA101','Patel','Makesh','7337 Shef eld St.','Seattle','WA', 98119),
    ('AK102','Aksoy','Ceyda','411 Grif n Rd.','Seattle','WA', 98131),
    ('CO103','Cole','Meerab','9486 Circle Ave.','Olympia','WA', 98506),
    ('KO104','Kowalczyk','Jakub','7431 S. Bishop St.','Bellingham','WA', 98226),
    ('SI105','Sims','Haydon','527 Primrose Rd.','Portland','OR', 97203),
    ('BU106','Burke','Ernest','613 Old Pleasant St.','Twin Falls','ID', 83303),
    ('RE107','Redman','Seth','7681 Fordham St.','Seattle','WA', 98119),
    ('LO108','Lopez','Janine','9856 Pumpkin Hill Ln.','Everett','WA', 98213),
    ('BI109','Bianchi','Nicole','7990 Willow Dr.','New York','NY', 10005),
    ('JO110','Jones','Ammarah','730 Military Ave.','Seattle','WA', 98126);

SELECT LAST_NAME,FIRST_NAME FROM OWNER
WHERE CITY IN ('Seattle')