다음 테이블 인스턴스(Instance)들에 대하여 오류 없이 동작하는 SQL(Structured Query Language) 문장은?
1
SELECT deptno, position, AVG(salary)
FROM PROFESSOR
GROUP BY deptno;
FROM PROFESSOR
GROUP BY deptno;
2
(SELECT studno, name
FROM STUDENT
WHERE deptno = 101)
UNION
(SELECT profno, name
FROM PROFESSOR
WHERE deptno = 101);
FROM STUDENT
WHERE deptno = 101)
UNION
(SELECT profno, name
FROM PROFESSOR
WHERE deptno = 101);
3
SELECT grade, COUNT(*), AVG(height)
FROM STUDENT
WHERE COUNT(*) > 2
GROUP BY grade;
FROM STUDENT
WHERE COUNT(*) > 2
GROUP BY grade;
4
SELECT name, grade, height
FROM STUDENT
WHERE height > (SELECT height, grade
FROM STUDENT
WHERE name = '홍길동');
FROM STUDENT
WHERE height > (SELECT height, grade
FROM STUDENT
WHERE name = '홍길동');