(vi) Display details of jobs where the minimum salary is greater than 10000.

SELECT *
FROM JOBS
WHERE MIN_SALARY > 10000;

(vii) Display the first name and join date of the employees who joined between 2002 and 2005.

SELECT FIRST_NAME, HIRE_DATE
FROM EMPLOYEES
WHERE TO_CHAR(HIRE_DATE, 'YYYY') BETWEEN 2002 AND 2005
ORDER BY HIRE_DATE;

(viii) Display first name and join date of the employees who are either IT Programmers or Sales Managers.

SELECT FIRST_NAME, HIRE_DATE
FROM EMPLOYEES
WHERE JOB_ID IN ('IT_PROG', 'SA_MAN');

(ix) Display first name, salary, commission percentage, and hire date for employees with a salary less than 10000.

SELECT FIRST_NAME, SALARY, COMMISSION_PCT, HIRE_DATE
FROM EMPLOYEES
WHERE SALARY < 10000;

(x) Display job title and the difference between minimum and maximum salaries for jobs with a maximum salary in the range 10000 to 20000.

SELECT JOB_TITLE, MAX_SALARY - MIN_SALARY AS DIFFERENCE
FROM JOBS
WHERE MAX_SALARY BETWEEN 10000 AND 20000;

(xi) Display first name, salary, and salary rounded to thousands.

SELECT FIRST_NAME, SALARY, ROUND(SALARY, -3)
FROM EMPLOYEES;

(xii) Display employees whose first name or last name starts with S.

SELECT FIRST_NAME, LAST_NAME
FROM EMPLOYEES
WHERE FIRST_NAME LIKE 'S%'
   OR LAST_NAME LIKE 'S%';

(xiii) Display details of employees whose commission percentage is NULL, salary is between 5000 and 10000, and department ID is 30.

SELECT *
FROM EMPLOYEES
WHERE COMMISSION_PCT IS NULL
  AND SALARY BETWEEN 5000 AND 10000
  AND DEPARTMENT_ID = 30;

(xiv) Display the first name and date of the first day of the month following the employees' hire month.

SELECT FIRST_NAME, HIRE_DATE, LAST_DAY(HIRE_DATE) + 1
FROM EMPLOYEES;

(xv) Display first name and last name with the first letter of each name in uppercase and the remaining letters in lowercase.

SELECT INITCAP(FIRST_NAME), INITCAP(LAST_NAME)
FROM EMPLOYEES;