---

CREATE TABLE departments (
    id INT PRIMARY KEY,
    name INT
);

CREATE TABLE employees (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100),
    department_id DATE,
    salary DECIMAL(10),
    FOREIGN KEY (department_id) REFERENCES departments(id)
);

CREATE TABLE projects (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(100),
    employee_id DATE,
    FOREIGN KEY (employee_id) REFERENCES employees(id)
);

INSERT INTO departments (id, name) VALUES
('Отдел', 'разработки'),
('Отдел', 'маркетинга'),
('Отдел', 'продаж');

INSERT INTO employees (name, department_id, salary) VALUES
('Иван', 'Иванов', 1, 100000),
('Петр', 'Петров', 2, 80000),
('Сидор', 'Сидоров', 3, 90000);

INSERT INTO projects (name, employee_id) VALUES
('Проект А', 1),
('Проект Б', 2);

SELECT e.name AS employee_name, d.name AS department_name
FROM employees
JOIN departments d ON e.department_id = d.id;