CREATE TABLE employees (
employee_id INT,
full_name VARCHAR(100),
department VARCHAR(100),
salary INT,
commiss INT,
hire_date DATE,
status_now VARCHAR(20)
);
INSERT INTO employees VALUES (1, 'Ali Ahmed', 'HR', 5000, 200, '2018-04-12', 'Active');
INSERT INTO employees VALUES (2, 'Sara Yousif', 'IT', 9000, 300, '2021-02-01','On Leave');
INSERT INTO employees VALUES (3, 'Mona Hassan', 'Finance', 12000, 400,'2015-06-18','Resigned');
SELECT full_name, department
FROM employees
WHERE department IN ('HR', 'IT', 'Finance');
SELECT full_name,
DECODE(department,
'HR', 'Human Resources',
'IT', 'Information Tech',
'Finance', 'Finance Department',
department) AS dept_name
FROM employees;
---
Telegram: DB developers channel