CREATE TABLE employees (
employee_id INT PRIMARY KEY,
first_name VARCHAR(50),
last_name VARCHAR(50),
department_id INT,
salary DECIMAL(10, 2)
);
INSERT INTO employees (employee_id, first_name, last_name, department_id, salary) VALUES
(1, 'Cameron', 'Diaz', 1, 5000),
(2, 'Alexey', 'Vishnia', 1, 6000),
(3, 'Jim', 'Carrey', 2, 5500),
(4, 'Vanessa', 'Mae', 2, 7000),
(5, 'Eddie', 'Murphy', 3, 7500);
SELECT * FROM employees;
Telegram: DB developers channel