-- 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
employee_id,
first_name,
last_name,
job_title,
salary AS monthly_salary,
ROUND(salary / 30, 2) AS daily_wages -- Calculate daily wages for each manager, rounded to 2 decimal places
FROM employees
WHERE job_title = 'Manager';
Telegram: DB developers channel