-- List the owner number, last name, and first name of every property owner.
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 OWNER_NUM,LAST_NAME,FIRST_NAME FROM OWNER