NVL함수와 CASE문(NULL값과 조건문 쿼리)

NVL 함수
SELECT payno, part, sawon, age, address,
       month, gdate, bonbong, tax, bonus,
       family
FROM itpay;

SELECT payno, part, sawon, age, address,
       month, gdate, bonbong, tax,
       NVL(bonus, 0) + 500000 as bonus,
       NVL(family, 0)
FROM itpay;

CASE 문
SELECT payno, part, sawon, age, address,
       month, gdate, bonbong, tax,
       CASE part WHEN '개발팀' THEN 1.4*bonbong
                 WHEN '객체개발팀' THEN 1.3*bonbong
                 WHEN 'DB설계팀' THEN 1.2*bonbong
       ELSE 1.1*bonbong END bonus
FROM itpay;