실습문제_3장-0.pdf

SELECT
    DEPTNO
    ,floor(AVG(SAL)) "AVG"
FROM EMP
GROUP BY DEPTNO
HAVING AVG(SAL)>2000;

실습문제_SUM-1.pdf

SELECT 
    sum(pay) "SUM",
    AVG(PAY) "A",
    MAX(PAY) "X",
    MIN(PAY) "N",
    ROUND( STDDEV(PAY),2) "S",
    ROUND(VARIANCE(PAY),2) "V"
FROM professor

실습문제_AVG-1.pdf

SELECT 
   POSITION,
    ROUND(AVG(PAY),2) "AVG"
    
FROM professor
GROUP BY POSITION
HAVING AVG(PAY)>300;

실습문제_3장-1.pdf

SELECT 
    MIN(DECODE(DAY,'SUN',DAYNO)) "SUN",
    MIN(DECODE(DAY,'MON',DAYNO)) "MON",
    MIN(DECODE(DAY,'TUE',DAYNO)) "TUE",
    MIN(DECODE(DAY,'WED',DAYNO)) "WED",
    MIN(DECODE(DAY,'THU',DAYNO)) "THU",
    MIN(DECODE(DAY,'FRI',DAYNO)) "FRI",
    MIN(DECODE(DAY,'SAT',DAYNO)) "SAT"
FROM CAL
GROUP BY WEEKNO
ORDER BY WEEKNO;