cookbook_16.sql

CREATE TABLE employees (
    employee_id INT PRIMARY KEY,
    employee_name VARCHAR(50),
    department_id INT
);

CREATE TABLE departments (
    department_id INT PRIMARY KEY,
    department_name VARCHAR(50)
);

INSERT INTO employees (employee_id, employee_name, department_id)
VALUES
    (1, 'John', 1),
    (2, 'Jane', 2),
    (3, 'Bob', NULL),
    (4, 'Alice', 4);

INSERT INTO departments (department_id, department_name)
VALUES
    (1, 'HR'),
    (2, 'Finance'),
    (3, 'Marketing');