INSERT INTO departments
    (name)
VALUES
    ('Sales'),
    ('Engineering'),
    ('Finance'),
    ('Legal');

INSERT INTO roles 
    (title,salary,department_id)
VALUES
    ('Sales Manager',120000,1),
    ('Salesperson',80000,1),
    ('Lead Engineer',150000,2),
    ('Software Engineer',120000,2),
    ('Account Manager',160000,3),
    ('Accountant',125000,3),
    ('Legal Team Lead',250000,4),
    ('Lawyer',190000,4);


INSERT INTO employee
    (first_name,last_name,role_id,manager_id)
VALUES
    ('Jhon','Doe',1,NULL),
    ('Mike','Chan',2,1),
    ('Ashley','Rodriguez',3,NULL),
    ('Kevin','Tupik',4,3),
    ('Kunal','Singh',5,NULL),
    ('Malia','Brow',6,5),
    ('Sarah','Lourd',7,NULL),
    ('Tom','Allen',8,7)

    