INSERT INTO employees (employee_id, first_name, last_name, department_id, salary, hire_date, job_id, manager_id)
VALUES
    (1, 'John', 'Doe', 1, 50000.00, '2023-01-01', 1, NULL),
    (2, 'Jane', 'Smith', 2, 60000.00, '2023-02-01', 2, 1),
    (3, 'Michael', 'Johnson', 1, 45000.00, '2023-03-01', 1, 1);

INSERT INTO departments (department_id, department_name, location_id)
VALUES
    (1, 'Sales', 1),
    (2, 'Marketing', 2),
    (3, 'IT', 1);

INSERT INTO locations (location_id, street_address, city, state_province, country_id)
VALUES
    (1, '123 Main St', 'Anytown', 'CA', 'USA'),
    (2, '456 Oak Ave', 'Othertown', 'NY', 'USA');