DROP TABLE IF EXISTS employees;
CREATE TABLE employees (
  emp_id     INTEGER PRIMARY KEY,
  name       TEXT,
  department TEXT,
  hire_date  DATE,
  salary     INTEGER
);

INSERT INTO employees (name, department, hire_date, salary) VALUES
  ('Alice',  'Sales',      '2022-01-10', 95000),
  ('Bob',    'Engineering','2023-03-14',115000),
  ('Carlos', 'Finance',    '2021-07-22',100000),
  ('Dana',   'Engineering','2020-11-05',125000);
