CREATE TABLE sales_order 
   (id INTEGER NOT NULL PRIMARY KEY
    GENERATED ALWAYS AS IDENTITY, 
    customer_id INTEGER,
    salesperson_id INTEGER, 
    order_date DATE);
                                                                                                  
INSERT INTO sales_order VALUES (DEFAULT,  5,  1, '2004-04-03');

INSERT INTO sales_order VALUES (DEFAULT,  10,  1, '2004-04-05');

INSERT INTO sales_order VALUES (DEFAULT,  20,  2, '2004-05-01');

INSERT INTO sales_order VALUES (DEFAULT,  5,  1, '2004-05-10');

INSERT INTO sales_order VALUES (DEFAULT,  20,  2, '2004-06-05');