DROP TABLE app.employees;

CREATE TABLE app.employees (
        ID INTEGER GENERATED ALWAYS AS IDENTITY CONSTRAINT employees_pk PRIMARY KEY,
        first_name VARCHAR(50) NOT NULL,
        last_name VARCHAR(50) NOT NULL,
        job_title VARCHAR(50) NOT NULL,
        hire_date DATE NOT NULL,
        birth_date DATE NOT NULL,
        salary INTEGER
    );
  
    
INSERT INTO app.employees (first_name, last_name, birth_date, hire_date, job_title, salary)
VALUES ('Henry.J.', 'Waternoose', DATE('1953-05-11'), DATE('1990-04-01'), 'Chief Executive Officer', 5000);
INSERT INTO app.employees (first_name, last_name, birth_date, hire_date, job_title, salary)
VALUES ('James.P.', 'Sullivan', DATE('1978-04-06'), DATE('1999-07-15'), 'Senior Scarer', 2500);
INSERT INTO app.employees (first_name, last_name, birth_date, hire_date, job_title, salary)
VALUES ('Mike', 'Wazowski', DATE('1984-12-03'), DATE('2003-11-01'), 'Junior Scarer', 2000);
INSERT INTO app.employees (first_name, last_name, birth_date, hire_date, job_title, salary)
VALUES ('Celia', 'Mae', DATE('1979-06-13'), DATE('1998-09-30'), 'Receptionist', 1500);
INSERT INTO app.employees (first_name, last_name, birth_date, hire_date, job_title, salary)
VALUES ('Abominable', 'Snowman', DATE('1957-07-23'), DATE('1990-04-01'), 'Snowman', 3000);
INSERT INTO app.employees (first_name, last_name, birth_date, hire_date, job_title, salary)
VALUES ('Randall', 'Boggs', DATE('1973-08-31'), DATE('1997-01-01'), 'Senior Scarer', 2500);
INSERT INTO app.employees (first_name, last_name, birth_date, hire_date, job_title, salary)
VALUES ('Roz', '', DATE('1903-03-26'), DATE('1990-04-01'), 'Bookkeeper', 2700);
    
