ข้อ 1

select job_id
from hr.employees;

ข้อ 2

select EMPLOYEE_ID	|| ',' || 
    FIRST_NAME || ',' ||
    LAST_NAME	|| ',' || 
    EMAIL	|| ',' ||
    PHONE_NUMBER || ',' || 
    HIRE_DATE	|| ',' ||
    JOB_ID	|| ',' || 
    SALARY || ',' ||
    COMMISSION_PCT || ',' ||  
    MANAGER_ID || ',' ||
   	DEPARTMENT_ID as "THE_OUTPUT"
from hr.employees;

ข้อ 3

select first_name as "First Name" , last_name as "Last Name" ,salary || '' || commission_pct as "Total Salary"
from hr.employees;

ข้อ 4

select first_name as "First Name" , last_name as "Last Name" ,salary || '' || commission_pct as "Total Salary" ,job_id as "Job ID"
from hr.employees
where job_id = 'IT_PROG';

ข้อ 5

select last_name as "Last Name" ,email as "Mail" ,phone_number as "Telephone",job_id as "Job ID",manager_id,department_id
from hr.employees
where manager_id = 103 and department_id = 60;