select lower(job), initcap(ename)
from employees
where upper(job) = 'SALESREP'
order by length(ename);
LOWER(JOB) INITCAP(ENAME)
---------- --------------
salesrep Ward
salesrep Allen
salesrep Martin
salesrep Turner
from employees
where upper(job) = 'SALESREP'
order by length(ename);
LOWER(JOB) INITCAP(ENAME)
---------- --------------
salesrep Ward
salesrep Allen
salesrep Martin
salesrep Turner