연봉 높은 순으로 정렬하기

employees 테이블 이용

select rownum,
	name as Full_name ,
	substr(name,1,(instr(name,' ')-1)) as Fmaily_name,
	substr(name,(instr(name,' ')),20) as Given_name,
	HIRE_DATE,
	to_char(SALARY*12, '$999,999,999') as Total_sal
from (select
	name,
	substr(name,1,(instr(name,' ')-1)),
	substr(name,(instr(name,' ')),20),
	HIRE_DATE,
	SALARY
         from employees)
order by Total_sal desc
/