-- create a table
CREATE TABLE REP (
    REP_ID CHAR(2) PRIMARY KEY,
    FIRST_NAME CHAR(20),
    LAST_NAME VARCHAR(20),
    ADDRESS CHAR(20),
    CITY CHAR(15),
    STATE CHAR(2),
    POSTAL CHAR(5),
    CELL_PHONE CHAR(12),
    COMMISSION NUMERIC(7,2),
    RATE NUMERIC(3,2)
);
INSERT INTO REP VALUES ( 
    '35', 
    'fred', 
    'Kiser', 
    '427 Billings Dr', 
    'Cody', 
    'WY', 
    '82414', 
    '307-555-6309',
    0.00, 
    0.05);
DROP TABLE REP;