Ghjjj

CREATE TABLE employees (employee_id INT PRIMARY KEY,first_name VARCHAR(50),last_name

VARCHAR(50), job_title VARCHAR(50),department_id INT,salary INT);

INSERT INTO employees (employee_id, first_name, last_name, job_title, department_id, salary) VALUES

(1, ‘John’, ‘Smith’, ‘Manager’, 101, 80000),

(2, ‘Jane’, ‘Doe’, ‘Analyst’, 102, 60000),

(3, ‘Michael’, ‘Johnson’, ‘Clerk’, 101, 45000),

(4, ‘Emily’, ‘Williams’, ‘Manager’, 103, 85000),

(5, ‘David’, ‘Brown’, ‘Analyst’, 102, 65000);