CREATE TABLE employees (
emp_id INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
age INT CHECK (age > 18),
salary DECIMAL(10,2),
hire_date DATE DEFAULT CURRENT_DATE
);
INSERT INTO employees (first_name, last_name, age, salary)
VALUES ('Ali', 'Hassan', 30, 50000);
select * from employees;