예제 3-9 employees에서 employee_id를 ‘사원번호’, salary를 ‘급여’, salary+500을 ‘추가급여’, salary-100을 ‘인하급여’, (salary*1.1)/2를 ‘조정급여’로 출력하세요.

SELECT employee_id AS 사원번호,

       salary AS 급여,

       salary+500 AS 추가급여,

       salary-100 AS 인하급여,

       (salary*1.1)/2 AS 조정급여

FROM   employees;

 

실행 결과