SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE employees ( employee_id SERIAL PRIMARY KEY, first_name VARCHAR(50) NOT NULL, middle_name VARCHAR(50), last_name VARCHAR(50) NOT NULL CHECK (last_name <> ''), hire_date DATE CHECK (hire_date > '2000-01-01'), email VARCHAR(100) UNIQUE, salary DECIMAL(10, 2) DEFAULT 50000.00 -- department_id INT REFERENCES departments(department_id) ); INSERT INTO employees (first_name, middle_name, last_name, hire_date, email, salary) VALUES ('Иван', NULL, 'Иванов', '2023-09-01', 'ivanov@example.com', 65000.00), ('Петр', 'Петрович', 'Петров', '2023-08-15', 'petrov@example.com', 75000.00), ('Анна', 'Сидоровна', 'Иванова', '2023-07-22', 'sidorova@example.com', 85000.00); SELECT * FROM employees;