SQLize | PHPize | SQLtest

-- 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 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; -- 4. Find the six-month salary of each employee SELECT employee_id, first_name, last_name, job_title, salary AS monthly_salary, salary * 6 AS six_month_salary FROM employees;