-- 1. Create the employees table with hire_date and job_title included
CREATE TABLE employees (
employee_id NUMBER PRIMARY KEY,
first_name VARCHAR2(50),
last_name VARCHAR2(50),
salary NUMBER,
hire_date DATE,
job_title VARCHAR2(50)
);
-- 2. Insert sample data with hire_date and job_title values
-- 2. Insert sample data with hire_date and job_title values
INSERT INTO employees VALUES (1, 'John', 'Smith', 5000, TO_DATE('2020-01-15', 'YYYY-MM-DD'), 'Manager');
INSERT INTO employees VALUES (2, 'Jane', 'Doe', 5000, TO_DATE('2021-03-10', 'YYYY-MM-DD'), 'Manager');
INSERT INTO employees VALUES (3, 'Alice', 'Johnson', 6000, TO_DATE('2019-07-22', 'YYYY-MM-DD'), 'Salesman');
INSERT INTO employees VALUES (4, 'Bob', 'Brown', 7000, TO_DATE('2022-11-01', 'YYYY-MM-DD'), 'Staff');
INSERT INTO employees VALUES (5, 'Charlie', 'Davis', 7000, TO_DATE('2023-04-05', 'YYYY-MM-DD'), 'Salesman');
INSERT INTO employees VALUES (6, 'Eve', 'White', 9000, TO_DATE('2018-06-30', 'YYYY-MM-DD'), 'Staff');
-- 3. Save the changes
COMMIT;
SELECT
first_name,
SUBSTR(first_name, 1, 1) AS first_char,
SUBSTR(first_name, 2, 1) AS second_char
FROM employees;
Telegram: DB developers channel