CREATE TABLE Employees (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    salary INT,
    department_id INT
);

CREATE TABLE Departments (
    id INT PRIMARY KEY,
    name VARCHAR(50)
);

INSERT INTO Departments (id, name) VALUES
(1, 'Engineering'),
(2, 'Marketing'),
(3, 'Sales');

INSERT INTO Employees (id, name, salary, department_id) VALUES
(1, 'John', 5000, 1),
(2, 'Sally', 6000, 1),
(3, 'Bob', 4500, 2),
(4, 'Jessica', 5500, 2),
(5, 'Robert', 4000, 3),
(6, 'Michelle', 6500, 3);